This section provides you with SQLite date and time functions that help you manipulate datetime data effectively.
| 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 | returns the Julian day, which is the number of days since noon in Greenwich on November 24, 4714 B.C. |
| STRFTIME | format a date value based on a specified format string. |
