Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/date.test
2025-04-10
| ||
10:18 | [180301372e] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 30978) | |
2025-01-21
| ||
17:37 | [8911c3d9fb] part of check-in [afb0a5923a] Fix date/time computations to deal with the sub-millisecond rounding problem identified in forum post 766a2c9231. (check-in: [afb0a5923a] user: drh branch: trunk, size: 30982) | |
2024-03-04
| ||
13:58 | [c8ff835023] part of check-in [dc56968374] Adjust date/time functions so that they do a better job of keeping track of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See forum post e7a939e074. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing. (check-in: [dc56968374] user: drh branch: trunk, size: 30591) | |
2024-03-03
| ||
20:15 | [99bfd3a77a] part of check-in [f0831cced2] Back out the previous change. Replace it with new date modifiers "ceiling" and "floor". (check-in: [f0831cced2] user: drh branch: trunk, size: 29449) | |
2024-03-02
| ||
20:50 | [9583b42105] part of check-in [296b46c529] Change the magic time-interval names that do truncate-to-same-month to be "mnth" and "yr" - "month" and "year" without the vowels. (check-in: [296b46c529] user: drh branch: month-truncate, size: 27258) | |
2024-01-18
| ||
16:50 | [b1a5208e6a] part of check-in [e1155d6aa4] Add support in the strftime() SQL function for conversion letters %G, %g, %U, and %V. (check-in: [e1155d6aa4] user: drh branch: trunk, size: 26789) | |
2023-11-04
| ||
21:44 | [ff2341a1ef] part of check-in [b692eb8ccb] Ensure that the YYYY-MM-DD input to date and time functions has been normalized prior to returning a result. Forum post 6bb476897e. (check-in: [b692eb8ccb] user: drh branch: trunk, size: 26795) | |
2023-08-29
| ||
18:28 | [c0d17cdfd8] part of check-in [058722b2d0] New conversion letters added to strftime(): %e, %k, %I, %l, %R, %P, %p, %T, %u. (check-in: [058722b2d0] user: drh branch: trunk, size: 26586) | |
2023-05-04
| ||
20:19 | [1d44557f66] part of check-in [6499ebff54] Add some tests of subsecond modifier for date/time functions. Sync with trunk. (check-in: [6499ebff54] user: larrybr branch: subsec-modifier, size: 25536) | |
2023-02-08
| ||
19:45 | [6220d9c15f] part of check-in [98d10cb52a] Be careful to maintain the value of 'txn' as long as there are active statements. Withdrawn See the attached Wiki page. (check-in: [98d10cb52a] user: drh branch: does-not-work, size: 27140) | |
12:31 | [8e9ae588d8] part of check-in [7b2fa20e31] Test cases to show that CURRENT_TIMESTAMP and similar hold the same value across a transaction. (check-in: [7b2fa20e31] user: drh branch: txn-date, size: 26907) | |
2023-02-07
| ||
23:55 | [0890bbd03f] part of check-in [d3bed4caff] Simplify the code and add test cases. (check-in: [d3bed4caff] user: drh branch: txn-date, size: 26459) | |
2022-03-05
| ||
20:12 | [118e04db8c] part of check-in [1c875b0764] Fix the 'localtime' modifier in date/time functions so that it preserves fractional seconds. Forum post 2ffbaa2c3fd7fb82. (check-in: [1c875b0764] user: drh branch: trunk, size: 25141) | |
2022-02-11
| ||
14:08 | [50d5b1eeec] part of check-in [f38071946a] Use the enhanced SQLITE_TESTCTRL_LOCALTIME_FAULT (2) capability to do better testing of the 'localtime' and 'utc' modifiers to date/time functions. (check-in: [f38071946a] user: drh branch: trunk, size: 24942) | |
2022-02-10
| ||
15:40 | [7e1da08fca] part of check-in [85cb601475] Performance improve to the 'localtime' and 'utc' modifiers for date/time functions. (check-in: [85cb601475] user: drh branch: trunk, size: 28223) | |
2017-03-03
| ||
20:43 | [9b73bbeb1b] part of check-in [8831f4393d] Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1]. (check-in: [8831f4393d] user: drh branch: trunk, size: 28223) | |
2017-03-02
| ||
23:40 | [e6da60d8ec] part of check-in [081dbcfb6d] Fix a bug in the 'start of ...' date/time modifiers when they follow a julian day number. Fix for ticket [6097cb92745327a1]. (check-in: [081dbcfb6d] user: drh branch: trunk, size: 28105) | |
2016-12-02
| ||
14:15 | [d8641ed74f] part of check-in [3c58b173d9] Fix a potential integer overflow during out-of-bound date computations. (check-in: [3c58b173d9] user: drh branch: date-overflow-fix, size: 27706) | |
2016-11-30
| ||
00:48 | [a6a5a48b90] part of check-in [dc453b3403] 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. (check-in: [dc453b3403] user: drh branch: trunk, size: 27658) | |
2016-11-29
| ||
20:39 | [47e7f7057c] part of check-in [d410a83975] 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. (check-in: [d410a83975] user: drh branch: trunk, size: 25207) | |
2015-12-23
| ||
10:54 | [984ac1e3e5] part of check-in [b910a3d537] 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. (check-in: [b910a3d537] user: drh branch: trunk, size: 25619) | |
2015-03-12
| ||
23:48 | [6b7c126180] part of check-in [3ac1f6a3cf] Fix the "now" option for date-time functions for cases when STAT4 is disabled. (check-in: [3ac1f6a3cf] user: drh branch: trunk, size: 25191) | |
2013-10-11
| ||
20:14 | [42973251b9] part of check-in [5e0d43ab55] Add requirements marks. No code changes. (check-in: [5e0d43ab55] user: drh branch: trunk, size: 25185) | |
2013-09-16
| ||
12:57 | [502ddcbaaa] part of check-in [daf6ba413c] The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). (check-in: [daf6ba413c] user: drh branch: trunk, size: 25004) | |
2012-06-19
| ||
03:11 | [f3228180c8] part of check-in [8ecffca900] Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases. (check-in: [8ecffca900] user: drh branch: floating-point-conversions, size: 24535) | |
2010-09-30
| ||
17:33 | [a18a2ce81a] part of check-in [ca154f97a5] Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. (check-in: [ca154f97a5] user: drh branch: experimental, size: 24534) | |
2010-06-23
| ||
15:55 | [6354b883f9] part of check-in [8d0f8a7f70] 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. (check-in: [8d0f8a7f70] user: dan branch: trunk, size: 24540) | |
2010-06-22
| ||
13:46 | [30269d897d] part of check-in [85dd51a75c] Some changes to test scripts related to codec enabled versions of sqlite. (check-in: [85dd51a75c] user: dan branch: trunk, size: 24455) | |
2009-04-16
| ||
12:58 | [0b8473ed9a] part of check-in [e6e036b345] 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) (check-in: [e6e036b345] user: drh branch: trunk, size: 24290) | |
2009-04-01
| ||
20:44 | [95a5611a67] part of check-in [a95b843a92] Fix the strftime() function so that the %s format can handle dates outside of the range of 1901 to 2038. Ticket #3769. (CVS 6430) (check-in: [a95b843a92] user: drh branch: trunk, size: 24110) | |
2009-01-30
| ||
17:27 | [bb2cc64833] part of check-in [86be908c5e] 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) (check-in: [86be908c5e] user: drh branch: trunk, size: 23591) | |
2008-07-08
| ||
02:12 | [4ea54e26fe] part of check-in [65875005ac] Add tests to verify correct behavior when mutex initialization fails. (CVS 5359) (check-in: [65875005ac] user: drh branch: trunk, size: 22366) | |
2008-06-12
| ||
18:05 | [1413c8a73d] part of check-in [c1006fb1c8] 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) (check-in: [c1006fb1c8] user: drh branch: trunk, size: 22187) | |
16:35 | [6ddaefb613] part of check-in [ed35f8a983] 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) (check-in: [ed35f8a983] user: drh branch: trunk, size: 22186) | |
05:16 | [fe0afe5d96] part of check-in [edd2cb00ae] Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209) (check-in: [edd2cb00ae] user: shane branch: trunk, size: 21760) | |
2008-05-20
| ||
14:01 | [a1554e1af1] part of check-in [14226ff0a7] Added more DST boundary checks for 2006 and 2007. Added check for suspect Windows DST implementations and warning about them. Ticket #2322. (CVS 5147) (check-in: [14226ff0a7] user: shane branch: trunk, size: 21267) | |
2008-04-15
| ||
04:02 | [be0a3a30f5] part of check-in [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) (check-in: [c5435f71ef] user: drh branch: trunk, size: 17935) | |
2008-02-21
| ||
20:40 | [8db95a0ba2] part of check-in [4c9a7b42b7] Accept "Z" as the zulu timezone at the end of date strings. (CVS 4805) (check-in: [4c9a7b42b7] user: drh branch: trunk, size: 16859) | |
2008-01-17
| ||
22:27 | [51734f3798] part of check-in [a676f949b6] Test coverage for date.c. (CVS 4722) (check-in: [a676f949b6] user: drh branch: trunk, size: 16312) | |
2007-08-31
| ||
17:42 | [b2bd57ff2a] part of check-in [d119427314] Allow sqllimits1.test to be run from a regular build of testfixture. Add the 'amalgamation-testfixture' target to main.mk - to build testfixture via sqlite3.c. (CVS 4354) (check-in: [d119427314] user: danielk1977 branch: trunk, size: 16171) | |
2007-05-04
| ||
13:15 | [4834d022b2] part of check-in [ba4845b32b] Eliminate all uses of sprintf() and strcpy(). These were not being misused. But getting rid of them removes a library dependency. And it avoids warnings from the OpenBSD compiler. Ticket #2336. (CVS 3916) (check-in: [ba4845b32b] user: drh branch: trunk, size: 15818) | |
2007-04-06
| ||
02:32 | [09786cf014] part of check-in [a776d93cca] Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) (check-in: [a776d93cca] user: drh branch: trunk, size: 15819) | |
2007-03-29
| ||
17:57 | [bc3c390d55] part of check-in [e853067ec4] Make sure the strftime() date conversions put in leading zeros correctly. Ticket #2276. (CVS 3749) (check-in: [e853067ec4] user: drh branch: trunk, size: 14201) | |
2007-01-08
| ||
16:19 | [63cc718e1d] part of check-in [d49ddc5ff0] Fix another round-off problem in strftime(). Ticket #2153. (CVS 3574) (check-in: [d49ddc5ff0] user: drh branch: trunk, size: 14000) | |
13:07 | [d46b7fa0c1] part of check-in [5206793780] Fix a round-off error in the %W and %j conversions of the strftime() function. Ticket #2150. (CVS 3570) (check-in: [5206793780] user: drh branch: trunk, size: 13390) | |
2006-09-25
| ||
18:03 | [03195d0491] part of check-in [51b9c755ea] Fix a roundoff error in the %f converter of strftime(). Ticket #1991. (CVS 3442) (check-in: [51b9c755ea] user: drh branch: trunk, size: 12697) | |
2006-09-08
| ||
12:27 | [0f39a64f8f] part of check-in [c81eaa0dc9] Bug fix in date/time computations. Ticket #1964. Some unrelated comment typos are also fixed and got accidently checked in at the same time. (CVS 3396) (check-in: [c81eaa0dc9] user: drh branch: trunk, size: 12535) | |
2006-09-01
| ||
15:49 | [fa6cc4e5fb] part of check-in [bedbac54db] Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) (check-in: [bedbac54db] user: drh branch: trunk, size: 12389) | |
2006-01-09
| ||
00:18 | [288b41dbcc] part of check-in [94c87b7016] Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) (check-in: [94c87b7016] user: drh branch: trunk, size: 12295) | |
2005-03-21
| ||
00:43 | [30ca15e608] part of check-in [2bf88daa57] Allow the character "T" between date and time in ISO-8601 date/time formats. Ticket #1170. (CVS 2408) (check-in: [2bf88daa57] user: drh branch: trunk, size: 12295) | |
2005-01-15
| ||
01:52 | [ef6c679d0b] part of check-in [92f9d2b2f4] Test coverage improvements. (CVS 2215) (check-in: [92f9d2b2f4] user: drh branch: trunk, size: 12045) | |
2004-10-31
| ||
02:22 | [dda578ec18] part of check-in [be661acfa8] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acfa8] user: drh branch: trunk, size: 11815) | |
2004-10-30
| ||
20:23 | [b4f8bb8e3e] part of check-in [2aa506ccb0] Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) (check-in: [2aa506ccb0] user: drh branch: trunk, size: 11825) | |
2004-08-20
| ||
18:34 | [fd3db29bba] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 11682) | |
2004-07-18
| ||
22:25 | [aa4bc2aae3] part of check-in [135e5447f6] The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1806) (check-in: [135e5447f6] user: drh branch: version_2, size: 11644) | |
22:22 | [a5cdaed88f] part of check-in [50b016b004] The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1805) (check-in: [50b016b004] user: drh branch: trunk, size: 11640) | |
2004-02-29
| ||
01:08 | [aed5030482] part of check-in [7b3b8968ee] One more fix to the new HH:MM:SS modifier. This time add some test procedures too. (CVS 1280) (check-in: [7b3b8968ee] user: drh branch: trunk, size: 10996) | |
2004-02-21
| ||
03:28 | [80cc84210b] part of check-in [ffa9719348] Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255) (check-in: [ffa9719348] user: drh branch: trunk, size: 9933) | |
2004-01-07
| ||
03:29 | [bb3ce39211] part of check-in [70df32b716] Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) (check-in: [70df32b716] user: drh branch: trunk, size: 9536) | |
2004-01-02
| ||
15:08 | [4ef4cfd6ae] part of check-in [720b565e2d] The "EST" timezone designation is ambiguous. Do not use it in the test scripts. (CVS 1155) (check-in: [720b565e2d] user: drh branch: trunk, size: 7866) | |
2003-12-23
| ||
16:34 | [8fe7fab4e9] part of check-in [a5a5fbd601] Update date/time functions so that they correctly handle NULL arguments. (CVS 1147) (check-in: [a5a5fbd601] user: drh branch: trunk, size: 7827) | |
16:22 | [510cf3dbc0] part of check-in [8482b8c447] Add localtime<-->UTC conversions to the date functions. (CVS 1146) (check-in: [8482b8c447] user: drh branch: trunk, size: 7063) | |
2003-11-01
| ||
01:53 | Added: [17619ff81d] part of check-in [68ef9b45bd] Revised date/time functions - now broken out into a separate source file. See the DateAndTimeFunctions wiki page for additional information. (CVS 1116) (check-in: [68ef9b45bd] user: drh branch: trunk, size: 5631) | |