On 2015-07-29 07:03, jose isaias cabrera wrote:
> sqlite> select datetime('now','start of day','localtime');
> 2015-07-28 20:00:00
I think, in your case in first resets hours for UTC time, and then
changes to your local time.
Try to change order of arguments (this should first change date to you
local time, and then set hours to 0):
sqlite> select datetime('now','localtime','start of day');
Regards,
RP.
