Re: [sqlite] sqlite: current_time is off

2007-02-19 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- P Kishor <[EMAIL PROTECTED]> wrote: > > On 2/18/07, Neil McLeod <[EMAIL PROTECTED]> wrote: > > > 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 > > >

Re: [sqlite] sqlite: current_time is off

2007-02-18 Thread Joe Wilson
--- P Kishor <[EMAIL PROTECTED]> wrote: > On 2/18/07, Neil McLeod <[EMAIL PROTECTED]> wrote: > > 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

Re: [sqlite] sqlite: current_time is off

2007-02-18 Thread P Kishor
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,