JULIAN_DAY

JULIAN_DAY function takes a date and returns the date as a Julian Day. A Julian Day is the number of days since Nov 24, 4714 BC 12:00pm Greenwich time in the Gregorian calendar.

Syntax

JULIAN_DAY(date)

Example

SELECT JULIAN_DAY('2016-10-18');

The above query returns:

2457680