Greetings!

if I run this command on the sqlite3 command tool,

select datetime('now','localtime');

I get,

sqlite> select datetime('now','localtime');
2015-07-29 00:48:07

which is correct.  When I run this command,

sqlite> select datetime('now','start of day','localtime');
2015-07-28 20:00:00

I am expecting 2015-07-29 00:00:00.  What does 'start of day' does/means? 
Thanks.

jos?

Reply via email to