97

Date and Time() Functions

In SQLite, date and time() functions are used to retrieve current date and time. The date and time functions use a subset of IS0-8601 date and time formats.

There are 6 different date and time functions which return and do calculation on date and time in different formats:

• SQLite date() Function
• SQLite datetime() Function
• SQLite julianday() Function
• SQLite now() Function
• SQLite strftime() Function
• SQLite time() Function

Index	Functions	Description
1)	SQLite date() function	The SQLite date() function is used to calculate the date and return it in the format ‘YYYY-MM-DD’.
2)	SQLite datetime() function	The SQLite datetime() function is used to calculate a date/time value, and return it in the format ‘YYYY-MM-DD HH:MM:SS’.
3)	SQLite julianday() function	The SQLite julianday() function returns the date according to julian day. A Julian Day is the number of days since Nov 24, 4714 BC 12:00pm Greenwich time in the Gregorian calendar. It returns the date as a floating point number.
4)	SQLite now() function	Actually now is not a function. Rather than it is a timestring parameter which is used in various SQLite functions to retrieve the current date and time.
5)	SQLite strftime() function	The SQLite strftime() function is used to return date in a formatted manner and also facilitates you to do calculation on dates.
6)	SQLite time() function	SQLite time() function is used to calculate time and return it in the format ‘HH-MM-SS’.

---