"Hick Gunter" wrote...
> You are converting the "start of day" (UTC) to "localtime". Your timezone
> is obviously 4 hours behind UTC...
>
> asql> SELECT datetime('now'),
> datetime('now','localtime'),datetime('now','start of
> day'),datetime('now','localtime','start of day'),datetime('now','start of
> day','localtime');
> datetime('now') = 2015-07-29 06:28:59
> datetime('now','localtime') = 2015-07-29 08:28:59
> datetime('now','start of day') = 2015-07-29 00:00:00
> datetime('now','localtime','start of day') = 2015-07-29 00:00:00
> datetime('now','start of day','localtime') = 2015-07-29 02:00:00
Thanks. These examples should be part of the documentation. ;-) I went to
the documentation and browse through it without getting deep into it.
Thanks again.
jos?
