|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1 |
|
| #
ea840117 |
| 05-Mar-2022 |
drh <> |
Fix the 'localtime' modifier in date/time functions so that it preserves fractional seconds. [forum:/forumpost/2ffbaa2c3fd7fb82|Forum post 2ffbaa2c3fd7fb82].
FossilOrigin-Name: 1c875b0764ab00e95c92f
Fix the 'localtime' modifier in date/time functions so that it preserves fractional seconds. [forum:/forumpost/2ffbaa2c3fd7fb82|Forum post 2ffbaa2c3fd7fb82].
FossilOrigin-Name: 1c875b0764ab00e95c92f0ee329659e88041763e125c2891201d80f68c41f717
show more ...
|
|
Revision tags: version-3.38.0 |
|
| #
85548fac |
| 11-Feb-2022 |
drh <> |
Use the enhanced SQLITE_TESTCTRL_LOCALTIME_FAULT (2) capability to do better testing of the 'localtime' and 'utc' modifiers to date/time functions.
FossilOrigin-Name: f38071946ac2e5bb61e6c0620507e4c
Use the enhanced SQLITE_TESTCTRL_LOCALTIME_FAULT (2) capability to do better testing of the 'localtime' and 'utc' modifiers to date/time functions.
FossilOrigin-Name: f38071946ac2e5bb61e6c0620507e4c94464999ac700d86c1a704b94eb1c009a
show more ...
|
| #
eadccaa9 |
| 10-Feb-2022 |
drh <> |
Performance improve to the 'localtime' and 'utc' modifiers for date/time functions.
FossilOrigin-Name: 85cb6014751a0572d28ebd839331d5d7a78de45c9e522adcd834a8a85746f32e
|
|
Revision tags: version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0 |
|
| #
35a0925a |
| 03-Mar-2017 |
drh <[email protected]> |
Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1].
FossilOrigin-Name: 8831f4393dda42b3434e7767968caea84bbca2af
|
| #
9715f7f0 |
| 02-Mar-2017 |
drh <[email protected]> |
Fix a bug in the 'start of ...' date/time modifiers when they follow a julian day number. Fix for ticket [6097cb92745327a1].
FossilOrigin-Name: 081dbcfb6d82528cefecb36c4491fa6e1a790b17
|
|
Revision tags: version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0 |
|
| #
d76a902c |
| 30-Nov-2016 |
drh <[email protected]> |
Further changes to the date/time functions to suppress harmless signed integer overflow warnings that could have occurred when doing out-of-range date calculations which, according to the docs, give
Further changes to the date/time functions to suppress harmless signed integer overflow warnings that could have occurred when doing out-of-range date calculations which, according to the docs, give undefined results.
FossilOrigin-Name: dc453b3403450b1d8cc53daf0721fed025b9053c
show more ...
|
| #
3edb157e |
| 29-Nov-2016 |
drh <[email protected]> |
The documentation says that the built-in date-time functions give undefined results for dates before 0000-01-01 and after 9999-12-31. Change the actually implementation so that the answer given is r
The documentation says that the built-in date-time functions give undefined results for dates before 0000-01-01 and after 9999-12-31. Change the actually implementation so that the answer given is really NULL. This also avoids unnecessary hand-wringing over an signed integer overflow that might otherwise occur when processing out-of-bound dates.
FossilOrigin-Name: d410a839752153c6d8be08f758abfbc16475745a
show more ...
|
|
Revision tags: version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0 |
|
| #
caeca516 |
| 23-Dec-2015 |
drh <[email protected]> |
Enhance the 'utc' modifier on date/time functions so that if the LHS is already known to be in UTC, the modifier becomes a no-op. This is not an incompatibility because the behavior is documented as
Enhance the 'utc' modifier on date/time functions so that if the LHS is already known to be in UTC, the modifier becomes a no-op. This is not an incompatibility because the behavior is documented as "undefined" in that scenario.
FossilOrigin-Name: b910a3d53769689d9212a06f974ccce54844bbe4
show more ...
|
|
Revision tags: version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9 |
|
| #
e9b9f759 |
| 13-Mar-2015 |
drh <[email protected]> |
Remove debugging logic accidently included in the previous check-in.
FossilOrigin-Name: 2887fb38ffc28712c34028cd38db2b7993d864eb
|
| #
3df79a9a |
| 12-Mar-2015 |
drh <[email protected]> |
Fix the "now" option for date-time functions for cases when STAT4 is disabled.
FossilOrigin-Name: 3ac1f6a3cf1a8fd3ab1ca96b2564c13c4b8d2234
|
|
Revision tags: version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2, version-3.8.1 |
|
| #
e4bf4f08 |
| 11-Oct-2013 |
drh <[email protected]> |
Add requirements marks. No code changes.
FossilOrigin-Name: 5e0d43ab55de006b20c58cb18b938d1c7b658e51
|
| #
95a7b3e3 |
| 16-Sep-2013 |
drh <[email protected]> |
The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step().
FossilOrigin-Name: daf6ba413cb3cb6065774ba07495eab4a28b49b0
|
|
Revision tags: version-3.8.0.2, version-3.8.0.1, version-3.8.0, version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14 |
|
| #
72b3fbc7 |
| 19-Jun-2012 |
drh <[email protected]> |
Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases.
FossilOrigin-Name: 8ecffca900cd6a8922001fd458a266ce8
Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases.
FossilOrigin-Name: 8ecffca900cd6a8922001fd458a266ce8c83fb66
show more ...
|
|
Revision tags: version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9, version-3.7.8, version-3.7.7.1, version-3.7.7, version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4 |
|
| #
025586a2 |
| 30-Sep-2010 |
drh <[email protected]> |
Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5].
FossilOrigin-Name: ca154f97a590745539b
Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5].
FossilOrigin-Name: ca154f97a590745539b2cbfd77eb319fd7392a40
show more ...
|
|
Revision tags: experimental, version-3.7.2 |
|
| #
10f5a50e |
| 23-Jun-2010 |
dan <[email protected]> |
Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN re
Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned.
FossilOrigin-Name: 8d0f8a7f70d6fb42369411a934b30f8c8ca8322f
show more ...
|
| #
68928b6c |
| 22-Jun-2010 |
dan <[email protected]> |
Some changes to test scripts related to codec enabled versions of sqlite.
FossilOrigin-Name: 85dd51a75c75b2a123744f646e04538e4e5d89b3
|
|
Revision tags: fts3-refactor, cvs-to-fossil-cutover, version-3.6.15 |
|
| #
7fee360d |
| 16-Apr-2009 |
drh <[email protected]> |
Make sure the 'unixepoch' converter in the date and time functions rounds to the nearest millisecond rather than truncating downward to the next smaller millisecond. Ticket #3808. (CVS 6512)
Fossil
Make sure the 'unixepoch' converter in the date and time functions rounds to the nearest millisecond rather than truncating downward to the next smaller millisecond. Ticket #3808. (CVS 6512)
FossilOrigin-Name: e6e036b345b130c207716c4b81719b5b7c884a11
show more ...
|
| #
6eb41523 |
| 01-Apr-2009 |
drh <[email protected]> |
Fix the strftime() function so that the %s format can handle dates outside of the range of 1901 to 2038. Ticket #3769. (CVS 6430)
FossilOrigin-Name: a95b843a9251ca9f9a23e8b67c2126f4c297a534
|
| #
c531a223 |
| 30-Jan-2009 |
drh <[email protected]> |
Fix a round-off error when moving dates by negative modifier amounts. Ticket #3618. Enhance the "NNN years" modifier to accept fractional years. (CVS 6220)
FossilOrigin-Name: 86be908c5e77ba2b9ac98e
Fix a round-off error when moving dates by negative modifier amounts. Ticket #3618. Enhance the "NNN years" modifier to accept fractional years. (CVS 6220)
FossilOrigin-Name: 86be908c5e77ba2b9ac98e394fa987b443d790f8
show more ...
|
|
Revision tags: version-3.6.10 |
|
| #
c8d75674 |
| 08-Jul-2008 |
drh <[email protected]> |
Add tests to verify correct behavior when mutex initialization fails. (CVS 5359)
FossilOrigin-Name: 65875005ac8bc7988d7d7d8e8b999857449568fd
|
| #
c91d86c9 |
| 12-Jun-2008 |
drh <[email protected]> |
Fix a typo in the date/time function tests. Add additional cases to the zeroblob tests to make sure sqlite3_bind_zeroblob() does not use excess memory. (CVS 5216)
FossilOrigin-Name: c1006fb1c817bc0
Fix a typo in the date/time function tests. Add additional cases to the zeroblob tests to make sure sqlite3_bind_zeroblob() does not use excess memory. (CVS 5216)
FossilOrigin-Name: c1006fb1c817bc0b7fada873edb772abbf972012
show more ...
|
| #
85f477a1 |
| 12-Jun-2008 |
drh <[email protected]> |
Convert the date/time functions to work with milliseconds since the julian epoch internally (instead of days since the epoch) in order to avoid problems with floating-point roundoff error. The inter
Convert the date/time functions to work with milliseconds since the julian epoch internally (instead of days since the epoch) in order to avoid problems with floating-point roundoff error. The interface is unchanged. (CVS 5215)
FossilOrigin-Name: ed35f8a98323dadb64b423615287fb24ea262ffb
show more ...
|
| #
f1aaaa40 |
| 12-Jun-2008 |
shane <[email protected]> |
Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209)
FossilOrigin-Name: edd2cb00ae606858d8ae138c69eee7821b8cd6ea
|
| #
05eaf73c |
| 20-May-2008 |
shane <[email protected]> |
Added more DST boundary checks for 2006 and 2007. Added check for suspect Windows DST implementations and warning about them. Ticket #2322. (CVS 5147)
FossilOrigin-Name: 14226ff0a7af7b39a1089a17ee
Added more DST boundary checks for 2006 and 2007. Added check for suspect Windows DST implementations and warning about them. Ticket #2322. (CVS 5147)
FossilOrigin-Name: 14226ff0a7af7b39a1089a17eeb5bbb8d09d778d
show more ...
|
| #
5f3a367b |
| 15-Apr-2008 |
drh <[email protected]> |
Fix a bug in the RTRIM collating sequence discovered while working on condition/decision branch coverage. Increase test coverage of the date/time functions. (CVS 5010)
FossilOrigin-Name: c5435f71ef
Fix a bug in the RTRIM collating sequence discovered while working on condition/decision branch coverage. Increase test coverage of the date/time functions. (CVS 5010)
FossilOrigin-Name: c5435f71efa0b34c759bac4a15fdf43abf39ddfc
show more ...
|