SQLite
View Ticket
Not logged in
Ticket UUID: 6097cb92745327a1244a110a63d6250edab36c45
Title: Broken 'start of day' modifier on date/time functions
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-03-02 23:41:15
Version Found In: 3.17.0
User Comments:
drh added on 2017-03-02 23:20:45: (text/x-fossil-wiki)
Beginning with check-in [768c9859b21a3c8] the SQL

<blockquote><verbatim>
SELECT datetime(2457754, 'start of day');
</verbatim></blockquote>

is return NULL instead of '2016-12-31 00:00:00'.  Issue reported on the
SQLite mailing list by Mark Brand.