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