Thank Igor,
It works.
Do you know where is wiki web for sqlite.
Thanks,
Joanne
----- Original Message ----
From: Igor Tandetnik <[EMAIL PROTECTED]>
To: SQLite <sqlite-users@sqlite.org>
Sent: Tuesday, December 18, 2007 10:40:30 AM
Subject: [sqlite] Re: How to convert the GMT time to date time format
Joanne Pham <joannekpham-/[EMAIL PROTECTED]> wrote:
> Thank Richard,
> What is the 'localtime' in this case. If my time zone is Pacific Time
> zone.
You actually put the string literal 'localtime'. SQLite uses whatever
time zone your operating system is configured to use.
If you want to use specific time zone, just figure out what the
difference from the GMT is and do something like
datetime(<integer>, 'unixepoch', '-8 hours');
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
