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