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:30
The 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:30
Code 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 do I use SQLite to retrieve data from a specific year?
- How do I use UUIDs in SQLite?
- How do I show the databases in SQLite?
- How can I use an upsert statement to update data in a SQLite database?
- How do I use the SQLite ZIP VFS to compress a database?
- How do I download and install SQLite zip?
- How can SQLite and ZFS be used together for software development?
- How can I query a SQLite database for records from yesterday's date?
- How do I use the SQLite SUBSTRING function?
- How do I use the SQLite zfill function?
See more codes...