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
(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 &
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
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
4 matches
Mail list logo