julianday

Applies julianday modifier to a date/time value.

This function applies the 'julianday' modifier in SQLite, which transforms a date/time value into the number of days that have passed since noon in Greenwich on November 24, 4714BC. according to the proleptic Gregorian calendar. The result is a floating-point number, where the fractional part represents the time of day.

Julian day numbers are useful for performing date arithmetic over long periods, as they provide a continuous, linear representation of time.

Example

// Get the Julian day number for the current date and time
select(DATETIME().now().julianday()).execute()

See also