JULIAN_DAY
Returns the integer value of the specified day according to the Julian calendar, where day 1 is the first day of the Julian period, January 1, 4713 BC (on the Gregorian calendar, November 24, 4714 BC).
Behavior Type
- Immutable if the
specified date is a
TIMESTAMP
,DATE
, orVARCHAR
- Stable if the specified date is a
TIMESTAMPTZ
Syntax
JULIAN_DAY ( date )
Parameters
date |
The date to process, one of the following data types: |
Example
=> SELECT JULIAN_DAY (DATE 'MARCH 15, 0044 BC'); JULIAN_DAY ------------ 1705428 (1 row) => SELECT JULIAN_DAY (DATE '2001-01-01'); JULIAN_DAY ------------ 2451911 (1 row)