Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/date.test
2017-03-03
| ||
20:43 | Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1]. file: [9b73bbeb] check-in: [8831f439] user: drh branch: trunk, size: 28223 | |
2017-03-02
| ||
23:40 | Fix a bug in the 'start of ...' date/time modifiers when they follow a julian day number. Fix for ticket [6097cb92745327a1]. file: [e6da60d8] check-in: [081dbcfb] user: drh branch: trunk, size: 28105 | |
2016-12-02
| ||
14:15 | Fix a potential integer overflow during out-of-bound date computations. file: [d8641ed7] check-in: [3c58b173] user: drh branch: date-overflow-fix, size: 27706 | |
2016-11-30
| ||
00:48 | 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. file: [a6a5a48b] check-in: [dc453b34] user: drh branch: trunk, size: 27658 | |
2016-11-29
| ||
20:39 | 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. file: [47e7f705] check-in: [d410a839] user: drh branch: trunk, size: 25207 | |
2015-12-23
| ||
10:54 | 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. file: [984ac1e3] check-in: [b910a3d5] user: drh branch: trunk, size: 25619 | |
2015-03-12
| ||
23:48 | Fix the "now" option for date-time functions for cases when STAT4 is disabled. file: [6b7c1261] check-in: [3ac1f6a3] user: drh branch: trunk, size: 25191 | |
2013-10-11
| ||
20:14 | Add requirements marks. No code changes. file: [42973251] check-in: [5e0d43ab] user: drh branch: trunk, size: 25185 | |
2013-09-16
| ||
12:57 | The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). file: [502ddcba] check-in: [daf6ba41] user: drh branch: trunk, size: 25004 | |
2012-06-19
| ||
03:11 | Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases. file: [f3228180] check-in: [8ecffca9] user: drh branch: floating-point-conversions, size: 24535 | |
2010-09-30
| ||
17:33 | Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. file: [a18a2ce8] check-in: [ca154f97] user: drh branch: experimental, size: 24534 | |
2010-06-23
| ||
15:55 | 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. file: [6354b883] check-in: [8d0f8a7f] user: dan branch: trunk, size: 24540 | |
2010-06-22
| ||
13:46 | Some changes to test scripts related to codec enabled versions of sqlite. file: [30269d89] check-in: [85dd51a7] user: dan branch: trunk, size: 24455 | |
2009-04-16
| ||
12:58 | 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) file: [0b8473ed] check-in: [e6e036b3] user: drh branch: trunk, size: 24290 | |
2009-04-01
| ||
20:44 | Fix the strftime() function so that the %s format can handle dates outside of the range of 1901 to 2038. Ticket #3769. (CVS 6430) file: [95a5611a] check-in: [a95b843a] user: drh branch: trunk, size: 24110 | |
2009-01-30
| ||
17:27 | 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) file: [bb2cc648] check-in: [86be908c] user: drh branch: trunk, size: 23591 | |
2008-07-08
| ||
02:12 | Add tests to verify correct behavior when mutex initialization fails. (CVS 5359) file: [4ea54e26] check-in: [65875005] user: drh branch: trunk, size: 22366 | |
2008-06-12
| ||
18:05 | 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) file: [1413c8a7] check-in: [c1006fb1] user: drh branch: trunk, size: 22187 | |
16:35 | 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) file: [6ddaefb6] check-in: [ed35f8a9] user: drh branch: trunk, size: 22186 | |
05:16 | Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209) file: [fe0afe5d] check-in: [edd2cb00] user: shane branch: trunk, size: 21760 | |
2008-05-20
| ||
14:01 | Added more DST boundary checks for 2006 and 2007. Added check for suspect Windows DST implementations and warning about them. Ticket #2322. (CVS 5147) file: [a1554e1a] check-in: [14226ff0] user: shane branch: trunk, size: 21267 | |
2008-04-15
| ||
04:02 | 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) file: [be0a3a30] check-in: [c5435f71] user: drh branch: trunk, size: 17935 | |
2008-02-21
| ||
20:40 | Accept "Z" as the zulu timezone at the end of date strings. (CVS 4805) file: [8db95a0b] check-in: [4c9a7b42] user: drh branch: trunk, size: 16859 | |
2008-01-17
| ||
22:27 | Test coverage for date.c. (CVS 4722) file: [51734f37] check-in: [a676f949] user: drh branch: trunk, size: 16312 | |
2007-08-31
| ||
17:42 | 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) file: [b2bd57ff] check-in: [d1194273] user: danielk1977 branch: trunk, size: 16171 | |
2007-05-04
| ||
13:15 | 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) file: [4834d022] check-in: [ba4845b3] user: drh branch: trunk, size: 15818 | |
2007-04-06
| ||
02:32 | Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) file: [09786cf0] check-in: [a776d93c] user: drh branch: trunk, size: 15819 | |
2007-03-29
| ||
17:57 | Make sure the strftime() date conversions put in leading zeros correctly. Ticket #2276. (CVS 3749) file: [bc3c390d] check-in: [e853067e] user: drh branch: trunk, size: 14201 | |
2007-01-08
| ||
16:19 | Fix another round-off problem in strftime(). Ticket #2153. (CVS 3574) file: [63cc718e] check-in: [d49ddc5f] user: drh branch: trunk, size: 14000 | |
13:07 | Fix a round-off error in the %W and %j conversions of the strftime() function. Ticket #2150. (CVS 3570) file: [d46b7fa0] check-in: [52067937] user: drh branch: trunk, size: 13390 | |
2006-09-25
| ||
18:03 | Fix a roundoff error in the %f converter of strftime(). Ticket #1991. (CVS 3442) file: [03195d04] check-in: [51b9c755] user: drh branch: trunk, size: 12697 | |
2006-09-08
| ||
12:27 | 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) file: [0f39a64f] check-in: [c81eaa0d] user: drh branch: trunk, size: 12535 | |
2006-09-01
| ||
15:49 | Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) file: [fa6cc4e5] check-in: [bedbac54] user: drh branch: trunk, size: 12389 | |
2006-01-09
| ||
00:18 | Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) file: [288b41db] check-in: [94c87b70] user: drh branch: trunk, size: 12295 | |
2005-03-21
| ||
00:43 | Allow the character "T" between date and time in ISO-8601 date/time formats. Ticket #1170. (CVS 2408) file: [30ca15e6] check-in: [2bf88daa] user: drh branch: trunk, size: 12295 | |
2005-01-15
| ||
01:52 | Test coverage improvements. (CVS 2215) file: [ef6c679d] check-in: [92f9d2b2] user: drh branch: trunk, size: 12045 | |
2004-10-31
| ||
02:22 | Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) file: [dda578ec] check-in: [be661acf] user: drh branch: trunk, size: 11815 | |
2004-10-30
| ||
20:23 | Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) file: [b4f8bb8e] check-in: [2aa506cc] user: drh branch: trunk, size: 11825 | |
2004-08-20
| ||
18:34 | Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [fd3db29b] check-in: [e97c3313] user: drh branch: trunk, size: 11682 | |
2004-07-18
| ||
22:25 | The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1806) file: [aa4bc2aa] check-in: [135e5447] user: drh branch: version_2, size: 11644 | |
22:22 | The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1805) file: [a5cdaed8] check-in: [50b016b0] user: drh branch: trunk, size: 11640 | |
2004-02-29
| ||
01:08 | One more fix to the new HH:MM:SS modifier. This time add some test procedures too. (CVS 1280) file: [aed50304] check-in: [7b3b8968] user: drh branch: trunk, size: 10996 | |
2004-02-21
| ||
03:28 | Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255) file: [80cc8421] check-in: [ffa97193] user: drh branch: trunk, size: 9933 | |
2004-01-07
| ||
03:29 | Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) file: [bb3ce392] check-in: [70df32b7] user: drh branch: trunk, size: 9536 | |
2004-01-02
| ||
15:08 | The "EST" timezone designation is ambiguous. Do not use it in the test scripts. (CVS 1155) file: [4ef4cfd6] check-in: [720b565e] user: drh branch: trunk, size: 7866 | |
2003-12-23
| ||
16:34 | Update date/time functions so that they correctly handle NULL arguments. (CVS 1147) file: [8fe7fab4] check-in: [a5a5fbd6] user: drh branch: trunk, size: 7827 | |
16:22 | Add localtime<-->UTC conversions to the date functions. (CVS 1146) file: [510cf3db] check-in: [8482b8c4] user: drh branch: trunk, size: 7063 | |
2003-11-01
| ||
01:53 | Revised date/time functions - now broken out into a separate source file. See the DateAndTimeFunctions wiki page for additional information. (CVS 1116) file: [17619ff8] check-in: [68ef9b45] user: drh branch: trunk, size: 5631 Added | |