Re: [sqlite] Dates & SQLite

2008-09-16 Thread bizshop
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

Re: [sqlite] Dates & SQLite

2008-09-15 Thread Ribeiro, Glauber
(integers), but those are slightly more cumbersome, because they require an aditional keyword ('unixepoch') to process. g -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 11:23 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Dates &

Re: [sqlite] Dates & SQLite

2008-09-15 Thread Igor Tandetnik
Brown, Daniel <[EMAIL PROTECTED]> wrote: > Could someone point me to the documentation regarding dates and > SQLite? http://sqlite.org/lang_datefunc.html > 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

[sqlite] Dates & SQLite

2008-09-15 Thread Brown, Daniel
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