Re: [sqlite] What is the best way to store date value in sqlite

[[EMAIL PROTECTED]]

Anyway get get Unix Epoch Time in Windows MFC, or win32?

[EMAIL PROTECTED] wrote:

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: sqlite-users@sqlite.org 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