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

Reply via email to