This section provides the SQLite date and time functions that help you effectively manipulate date and time data values.
| Name | Description |
| DATE | Calculate a date value based on multiple date modifiers. |
| TIME | Calculate a time value based on multiple date modifiers. |
| DATETIME | Calculate a date & time value based on one or more date modifiers. |
| JULIANDAY | Convert dates and times to Julian day numbers. |
| UNIXEPOCH | Return a unix timestamp of a date or datetime value. |
| STRFTIME | Format a date value based on a specified format string. |
| CURRENT_TIMESTAMP | Return the current date and time in UTC as a string with the format YYYY-MM-DD HH:MM:SS. |
| CURRENT_DATE | Return the current date in UTC as a string with the format YYYY-MM-DD. |
| CURRENT_TIME | Return the current time in UTC as a string with the format HH:MM:SS. |
Was this tutorial helpful?
Thank you for your feedback!
