> > SQLite version 3.1.2
> > Enter ".help" for instructions
> > sqlite> select datetime('now');
> > 2005-03-26 00:44:37
> > sqlite> .quit
> > zenobia # date
> > Fri Mar 25 18:44:48 CST 2005
> > zenobia #
> >
> > Is this because I don't have the timezone set?
>
> select datetime('now',
On Fri, Mar 25, 2005 at 04:48:47PM -0800, Jay wrote:
> SQLite version 3.1.2
> Enter ".help" for instructions
> sqlite> select datetime('now');
> 2005-03-26 00:44:37
> sqlite> .quit
> zenobia # date
> Fri Mar 25 18:44:48 CST 2005
> zenobia #
>
> Is this because I don't have the timezone set?
Jay wrote:
> SQLite version 3.1.2
> Enter ".help" for instructions
> sqlite> select datetime('now');
> 2005-03-26 00:44:37
> sqlite> .quit
> zenobia # date
> Fri Mar 25 18:44:48 CST 2005
> zenobia #
>
> Is this because I don't have the timezone set?
The time you are getting from SQLite is in
SQLite version 3.1.2
Enter ".help" for instructions
sqlite> select datetime('now');
2005-03-26 00:44:37
sqlite> .quit
zenobia # date
Fri Mar 25 18:44:48 CST 2005
zenobia #
Is this because I don't have the timezone set?
__
Do You Yahoo!?
Tired of
4 matches
Mail list logo