On 2/18/07, Neil McLeod <[EMAIL PROTECTED]> wrote:
Hello,
I just started using SQLite, and it seems my timestamps are all 5 hours
ahead of time (i.e. "select current_time" gives me 0:47 when it is actually
19:47 here). I guess this is GMT. Is there a way to adjust the time? I'm on
Windows XP, and the time is listed correctly in my taskbar.
by default, time is in UTC. Use 'localtime' modifier for your time.
select time('now', 'localtime');
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
