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?
select datetime('now', 'localtime') will compensate for your timezone.
