> On Nov 20, 2018, at 21:49, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote: > >> (Does SQL itself have a numeric timestamp type, or explicitly endorse the >> POSIX epoch for numeric timestamps?) > > SQL has an explicit TIMESTAMP type since SQL-92, one thing that I'm heavily > missing in SQlite ;-)
DATE '1998-12-25’ & TIMESTAMP '1997-01-31 09:26:50.124’ literals :)) But do *not* try this: sqlite> select DATE '1998-12-25’; ...> ...> …> sqlite3 -version 3.25.3 2018-11-05 20:37:38 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b75036f2 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
