Ming:
I asked the same question about two weeks ago to this same list. I was
directed to the following location:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I ended up saving my date/time in Unix Epoch Time. Then you can retrieve
with the datetime function SELECT datetime(column-name,'unixepoch') from
table-name. I use perl under Unix so I actually convert to Unix Epoch
format before updating table.
Regards,
[EMAIL PROTECTED]
NCCI
Boca Raton, Florida
561.893.2415
greetings / avec mes meilleures salutations / Cordialmente
mit freundlichen Gr��en / Med v�nlig h�lsning
"[EMAIL PROTECTED]
co.ca" <mqlin To: [email protected]
cc:
02/21/2005 05:29 Subject: [sqlite] What is the
best way to store date value in sqlite
PM
Please respond to
sqlite-users
Hi All,
I want to store MFC date (CTime or COleDateTime) value in sqlite, but
don't know what is the best way to store it. I am running into trouble
when I store date as Text in sqlite, because I can't no longer apply
sqlite date time functions( datetime(), date()...) to it. Result in I
can't do a order by the date filed.
The other question would be does sqlite have date limits (Upper Bound
and Lower Bound) for the datetime() functions.
Many thanks,
Ming
