sqliteHow do I store and retrieve datetime values in SQLite?
SQLite provides several functions to store and retrieve datetime values.
The strftime() function can be used to store datetime values in a SQLite database. It takes a datetime value and a format string as arguments and returns a string containing the formatted date and time. For example:
SELECT strftime('%Y-%m-%d %H:%M:%S', 'now');
2020-08-18 11:08:30The date() function can be used to retrieve datetime values from a SQLite database. It takes a string containing a formatted date and time and returns a datetime value. For example:
SELECT date('2020-08-18 11:08:30');
2020-08-18 11:08:30Code explanation
strftime()- Function used to store datetime values in a SQLite database.'now'- Datetime value used as argument for thestrftime()function.'%Y-%m-%d %H:%M:%S'- Format string used as argument for thestrftime()function.date()- Function used to retrieve datetime values from a SQLite database.'2020-08-18 11:08:30'- String containing a formatted date and time used as argument for thedate()function.
Helpful links
More of Sqlite
- How can I use the XOR operator in a SQLite query?
- How can SQLite and ZFS be used together for software development?
- How do I use SQLite with Zephyr?
- How do I import data from a SQLite zip file?
- How to configure SQLite with XAMPP on Windows?
- How do I use SQLite UNION to combine multiple SELECT queries?
- How do I extract the year from a datetime value in SQLite?
- How do I generate XML output from a SQLite database?
- How do I install SQLite on Windows?
- How do I use the SQLite round function?
See more codes...