SQLite Julianday Function
The SQLite julianday function facilitates you to apply modifiers and then returns the date as a Julian Day after taking the date as an input.
A Julian Day is the number of days since Nov 24, 4714 BC 12:00pm Greenwich time in the Gregorian calendar. The julianday function returns the date as a floating point number.
Example1: Retrieve current date:
Example2: Retrieve First Day of the Month:
Example2: Retrieve Last Day of the Month:
Example3: Add/ subtract years/ days on the current date: