"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? 

Reply via email to