On 11 Dec 2009, at 1:13pm, Florian Schricker wrote: > - CreateTS (Timestamp)
No such type in SQLite. Take a look at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions http://www.sqlite.org/lang_datefunc.html I'd recommend you store your time/date data either as strings (which would be a column type of TEXT) or as Unix epochs (which would be a column type of INTEGER). Either way, all you need to be sure of is that the field sorts in a consistent manner (i.e. that INDEX or ORDER BY on it will work). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
