[sqlite] datetime start of day result

[jose isaias cabrera]

"Rafal Ponikwia" wrote...

> 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');

DUH!  Thanks.