http://www.sqlite.org/lang_datefunc.html
This page has an error in documenting the range of values when using modifier 'unixepoch'. It says the limit is 10675199167. There should be one more digit in that to get the documented year 5352 result. --David Garfield Mihai Militaru writes: > On Thu, 21 Apr 2011 15:17:00 +0200 > Fabio Spadaro <[email protected]> wrote: > > > Does not work on python with sqlite3 module > > Try using the date and time functions, 'date' or 'datetime' in your case: > INSERT INTO table(..., date) VALUES(..., datetime('now')); > > http://www.sqlite.org/lang_datefunc.html > > -- > Mihai Militaru <[email protected]> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

