The JULIAN_DAY function returns an integer value representing a number of days from January 1, 4713 B.C. (the start of the Julian date calendar) to the date specified in the argument.
The result of the function is a large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value.
SELECT JULIAN_DAY(HIREDATE) INTO :JDAY FROM EMPLOYEE WHERE EMPNO = '000010'The result is that JDAY is set to 2438762.
SELECT JULIAN_DAY('1998-01-01') INTO :JDAY FROM SYSIBM.SYSDUMMY1The result is that JDAY is set to 2450815.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.