DATE_JULIAN
Syntax
DATE_JULIAN(year, month, day)
Parameters
year
Valid 2-digit or 4-digit year number.
month
Valid month number between 1-12.
day
Valid day number between 1-31.
Description
DATE_JULIAN
returns the Julian date of the specified input. The Julian date is the number of days elapsed since January 1, 0000.
Examples
DATE_JULIAN
(2000,08,31)
returns the number 730729.
Related Functions
Function
Description
DATE
Converts a date string to a Julian date.
DATE_FORMAT
Converts dates from one format to another.
DATE_STRING
Returns the date string of the Julian date.
Copyright IBM Corporation 2013. All Rights Reserved.