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