Thank Richard,
What is the 'localtime' in this case. If my time zone is Pacific Time zone.
Thanks,
Joanne
----- Original Message ----
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, December 18, 2007 10:14:14 AM
Subject: Re: [sqlite] How to convert the GMT time to date time format
Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have a table which has one of column is defined as INTEGER and stored the
> GMT time.
> I would like to convert this GMT time from INTEGER format to DATETIME format.
> Is there any function to convert from GMT in INTEGER to DATETIME format.
datetime(<integer>, 'unixepoch', 'localtime');
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
