DATE_JULIAN macro
The DATE_JULIAN
macro
is available only in HCL®
Campaign.
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. |