I use ISO time, which is 20080916122801 as I write this. It can be stored in integer format, is very easy to manipulate and sort. YearMonthDateHourMinuteSecond
Brown, Daniel wrote: > > Good morning list, > > Could someone point me to the documentation regarding dates and SQLite? > I'm having trouble finding anything about what data type I should use to > store dates in my SQLite tables, should it be a numerical type (integer > or real) or a string? > > Cheers, > > Daniel Brown | Software Engineer @ EA Canada > "The best laid schemes o' mice an' men, gang aft agley" > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Dates---SQLite-tp19496074p19518812.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
