Description
Returns the Julian datetime for the supplied Gregorian/common datetime.
Julian dates (abbreviated JD) are a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar). The time of day is represented by a decimal fraction. Since the Julian day starts at noon, .5 is midnight, and .75 is 6:00 a.m.
The Julian date and its constituent parts are often used by computer programs for calculations involving dates. The time between any two dates can be obtained by subtracting one from the other.
The day of the week for any Julian day can be calculated by taking the remainder after dividing the integer part by 7."
For more information: http://it.toolbox.com/wiki/index.php/Julian_date
Syntax
DATETIME2JULIANDATE ( "date" )
| Parameter | Description |
|---|---|
|
date |
A datetime value to be converted to a Julian date. |
Remarks
Note: Quotation marks are required around the date value.
Examples
The following function Returns the Julian date as 2455270.5:
DATETIME2JULIANDATE("3/15/2010")
To convert the current date and time to a Julian datetime, use DATETIME2JULIANDATE along with the NOW function, as follows:
DATETIME2JULIANDATE(NOW( ))
See also