/ View Ticket
Login
2017-03-03
20:43
Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1]. (check-in: 8831f439 user: drh tags: trunk)
2017-03-02
23:41 Fixed ticket [6097cb92]: Broken 'start of day' modifier on date/time functions plus 5 other changes (artifact: 451609e4 user: drh)
23:40
Fix a bug in the 'start of ...' date/time modifiers when they follow a julian day number. Fix for ticket [6097cb92745327a1]. (check-in: 081dbcfb user: drh tags: trunk)
23:20 New ticket [6097cb92] Broken 'start of day' modifier on date/time functions. (artifact: dc7e78fb user: drh)

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:

Beginning with check-in [768c9859b21a3c8] the SQL

SELECT datetime(2457754, 'start of day');

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