| SQLite | ||
|
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose. | ||
| Specific to SQLite | ||
| Thanks to Dan Bishop for supplying the SQLite examples. | ||