*** 73,79 **** Formats 5 through 7 that specify only a time assume a date of 2000-01-01. Format 8, the string 'now', is converted into the current date and time. Universal Coordinated Time (UTC) is used. ! Format 9 is the julian day number. *Modifiers* --- 73,79 ---- Formats 5 through 7 that specify only a time assume a date of 2000-01-01. Format 8, the string 'now', is converted into the current date and time. Universal Coordinated Time (UTC) is used. ! Format 9 is the julian day number expressed as a floating point value. *Modifiers* *************** *** 150,158 **** *Caveats And Bugs* The computation of local time depends heavily on the whim of local ! politians and is thus difficult to get correct for all locales. In this implementation, the standard C library function localtime() is ! used to assist in this calculation. Note that localtime() is not threadsafe, so use of the "localtime" modifier is not threadsafe. Also, the localtime() C function normally only works for years between 1970 and 2037. For dates outside this range, SQLite attempts to --- 150,159 ---- *Caveats And Bugs* The computation of local time depends heavily on the whim of local ! politicians and is thus difficult to get correct for all locales. In this implementation, the standard C library function localtime() is ! used to assist in the calculation of local time. ! Note that localtime() is not threadsafe, so use of the "localtime" modifier is not threadsafe. Also, the localtime() C function normally only works for years between 1970 and 2037. For dates outside this range, SQLite attempts to *************** *** 165,167 **** --- 166,169 ---- align it with the Julian calendar. This means that the "julian" modifier will not work right for dates that exist in the Julian calendar but which do not exist in the Gregorian calendar. + Example: 1900-02-29.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|