Sorry! I am very new to SQLite. Where is Wiki page. Thanks, Joanne
----- Original Message ---- From: P Kishor <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, December 18, 2007 10:29:05 AM Subject: Re: [sqlite] How to convert the GMT time to date time format On Dec 18, 2007 12:20 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Thank Richard, > What is the 'localtime' in this case. If my time zone is Pacific Time zone. 'localtime' is the keyword that tells SQLite to get the time from your computer's time zone setting. Read the datetime section on the wiki carefully. Most of your datetime questions will be answered. > 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 -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ Summer 2007 S&T Policy Fellow, The National Academies http://www.nas.edu/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ