Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/date.c
2025-02-27
| ||
21:17 | [9db4d604e6] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 49335) | |
2025-01-21
| ||
17:37 | [842c08ac14] 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: 49332) | |
2024-08-19
| ||
14:23 | [a3e9ff72b3] part of check-in [6767bf1c67] Fix leap-year handling for dates prior to 0400-03-01. (check-in: [6767bf1c67] user: drh branch: branch-3.46, size: 49166) | |
12:54 | [89ce1ff205] part of check-in [00cae11fff] Attempt to fix date/time calculations for days earlier than 0400-03-01. See forum thread eaa0a09786c6368b. (check-in: [00cae11fff] user: drh branch: ancient-date-fix, size: 49166) | |
2024-06-11
| ||
14:36 | [13dd752847] part of check-in [6c103aee6f] Change constant expressions to pre-computed constants, because apparently MSVC on ARM requires that. Forum thread 4feb1685cced0a8e. (check-in: [6c103aee6f] user: drh branch: trunk, size: 49125) | |
2024-03-04
| ||
18:22 | [126ba2ab10] part of check-in [178b7d46f9] Fix a compiler warning in date.c. Update makefiles to include all necessary dependencies for building shell.c. (check-in: [178b7d46f9] user: drh branch: trunk, size: 49125) | |
13:58 | [a9e4382961] 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: 49126) | |
11:12 | [29cecfe692] part of check-in [fc773f6c76] Fix assert() statements in date/time computations: The month and day numbers can be zero if an error has been seen. (check-in: [fc773f6c76] user: drh branch: trunk, size: 47940) | |
2024-03-03
| ||
20:15 | [b36a3cc75a] 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: 47972) | |
2024-03-02
| ||
20:50 | [89083264f1] 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: 46833) | |
13:38 | [f0bde50092] part of check-in [b606c09657] Proof-of-concept for new time-interval operator "pg-month" and "pg-year" that use the truncate-to-month algorithm for month overflow instead of the wrap-to-next-month algorithm that is used by SQLite by default. (check-in: [b606c09657] user: drh branch: month-truncate, size: 46756) | |
2024-01-21
| ||
21:20 | [90df32c2d8] part of check-in [382a8f94bf] Fix a harmless typo in a comment. (check-in: [382a8f94bf] user: drh branch: trunk, size: 46085) | |
2024-01-20
| ||
18:26 | [48a110a2a2] part of check-in [aaa5a044d8] Simplifications to the strftime() logic. (check-in: [aaa5a044d8] user: drh branch: trunk, size: 46051) | |
00:31 | [35ea61eb7a] part of check-in [b06ab46a9e] Implement a new algorithm for computing ISO week values in strftime() based on the idea (from Nuno Cruces) of shifting the date being tested to the Thursday of the same week. (check-in: [b06ab46a9e] user: drh branch: trunk, size: 45921) | |
2024-01-18
| ||
16:50 | [7ed194fee0] 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: 46495) | |
2023-11-04
| ||
21:44 | [3b8d02977d] 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: 43310) | |
2023-08-29
| ||
18:28 | [eebc54a00e] 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: 43125) | |
2023-06-19
| ||
13:09 | [f73f203b38] part of check-in [3c94f87806] Fix large integer constants so that they work on older C compilers. (check-in: [3c94f87806] user: drh branch: trunk, size: 42164) | |
2023-06-17
| ||
15:22 | [62e7936bc3] part of check-in [e46a00ae88] In date/time functions, fix the rendering of "subsecond" and the computeHMS() routine to better deal with floating point rounding errors that arise on some 32-bit systems. (check-in: [e46a00ae88] user: drh branch: trunk, size: 42136) | |
2023-06-16
| ||
14:39 | [36dfd2525c] part of check-in [365caf2f97] Address various harmless compiler warnings from forum post d526da8ee4. (check-in: [365caf2f97] user: drh branch: trunk, size: 43200) | |
2023-06-14
| ||
12:19 | [a93926302c] part of check-in [aebdbcbebf] Work around what appears to be a GCC 32-bit optimization problem in the computeHMS() routine of the date/time logic. (check-in: [aebdbcbebf] user: drh branch: trunk, size: 43148) | |
2023-06-13
| ||
16:55 | [17e090a9cd] part of check-in [d57ddbf4ee] Extended the time-diff format so that it can have a 5-digit year. This enables time differences to span the full range of dates supported by SQLite. Also fix some inaccuracies in the computation of time differences and add new test cases. (check-in: [d57ddbf4ee] user: drh branch: trunk, size: 42024) | |
2023-06-07
| ||
17:03 | [6e9549239d] part of check-in [8c291d9994] Fix straggler misspellings and tidy the custom dictionary. Also include pickups from forum post c61fb09afd. (check-in: [8c291d9994] user: larrybr branch: spell-check, size: 41818) | |
2023-05-30
| ||
14:46 | [cb71f73d5d] part of check-in [d6954259bd] Simplifications to the new timediff() logic. (check-in: [d6954259bd] user: drh branch: timediff, size: 41818) | |
11:13 | [fc60c1a37d] part of check-in [fa9237a8ab] Allow date/time modifiers of the form (+/-)YYYY-MM-DD without the following HH:MM:SS.SSS. (check-in: [fa9237a8ab] user: drh branch: timediff, size: 42117) | |
02:50 | [bd35fd6aad] part of check-in [cff293b0a7] Problems fixed. All tests are passing now. (check-in: [cff293b0a7] user: drh branch: timediff, size: 41911) | |
02:16 | [71c0484764] part of check-in [2cf6518140] Improvements to the timediff() function. Test cases added. Not all test cases are passing. (check-in: [2cf6518140] user: drh branch: timediff, size: 41874) | |
2023-05-29
| ||
20:33 | [3752bcd1a5] part of check-in [3832b8a9ef] New date/time modifier: (+|-)YYYY-MM-DD HH:MM(:SS.SSS)? (check-in: [3832b8a9ef] user: drh branch: timediff, size: 40641) | |
18:01 | [6ac049e14f] part of check-in [054a195125] Prototype implementation of a proposed "timediff(X,Y)" SQL function. (check-in: [054a195125] user: drh branch: timediff, size: 39501) | |
2023-04-21
| ||
15:30 | [aca9e0c08b] part of check-in [03f2a15e87] Add a new modifier to date/time functions: "subsecond". May be abbreviated as just "subsec". This modifier causes functions to try to show fractional seconds if they do not already. (check-in: [03f2a15e87] user: drh branch: subsec-modifier, size: 38029) | |
2023-02-11
| ||
21:11 | [f21815ca71] part of check-in [0216ce23cf] Change a variable from 32 to 64-bits to avoid a harmless compiler warning in Xcode. Forum post 402d733c22. (check-in: [0216ce23cf] user: drh branch: trunk, size: 36495) | |
2023-02-08
| ||
12:01 | [37ca5e3cb3] part of check-in [06180caff0] Revert the behavior of date/time functions with no arguments so that they once again work like 'now', even while CURRENT_TIMESTAMP and similar work like 'txn'. (check-in: [06180caff0] user: drh branch: txn-date, size: 37064) | |
11:34 | [7bbe94be3c] part of check-in [1ac78be545] Change the behavior of date-time functions without any arguments (and thus the CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP variables) so that they work like 'txn' instead of like 'now'. This is an incompatibility with legacy, but brings SQLite into conformance with all other SQL systems. (check-in: [1ac78be545] user: drh branch: txn-date, size: 36847) | |
2023-02-07
| ||
23:55 | [0c5db79ea1] part of check-in [d3bed4caff] Simplify the code and add test cases. (check-in: [d3bed4caff] user: drh branch: txn-date, size: 36844) | |
21:55 | [ff2d10db98] part of check-in [5e4f45af96] Add support for the 'txn' argument to date/time functions that works like 'now' but keeps the same time for the entire transaction. (check-in: [5e4f45af96] user: drh branch: txn-date, size: 37161) | |
2022-08-08
| ||
16:25 | [94ce83b4cd] part of check-in [3518cd7cb1] Avoid trying to cast an over-sized floating point value into an integer. (check-in: [3518cd7cb1] user: drh branch: trunk, size: 36495) | |
2022-07-19
| ||
21:12 | [2721625541] part of check-in [e5e9311863] Improve accuracy of julian day milliseconds calculation. (check-in: [e5e9311863] user: larrybr branch: trunk, size: 36491) | |
2022-03-05
| ||
20:12 | [1508256622] 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: 36485) | |
2022-02-21
| ||
14:30 | [1abbd739ae] part of check-in [5c188243d7] Fix compiler warnings for older compilers (ex: gcc 4.0.1 powerpc-apple-darwin). (check-in: [5c188243d7] user: drh branch: trunk, size: 36463) | |
2022-02-10
| ||
23:12 | [1fcc64294b] part of check-in [64537a0669] Fix SQLITE_TESTCTRL_LOCALTIME_FAULT so that it works even if mutexes are enabled. (check-in: [64537a0669] user: drh branch: trunk, size: 36357) | |
21:26 | [4088c04268] part of check-in [6e25cb0890] Enhance SQLITE_TESTCTRL_LOCALTIME_FAULT so that is able to install an alternative localtime() interface so that the localtime logic an be better tested. (check-in: [6e25cb0890] user: drh branch: trunk, size: 36340) | |
15:40 | [9d865dac4a] 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: 35865) | |
12:57 | [c9275705b0] part of check-in [fa1b393bdb] Faster implementation of the date(), time(), and datetime() functions. (check-in: [fa1b393bdb] user: drh branch: trunk, size: 35646) | |
2022-01-27
| ||
13:52 | [41627dec39] part of check-in [64fa9e8c87] Enforce the restriction that 'unixepoch' only works as the first modifier after the time-value. This has been documented since 2004, but has never actually been enforced before. Also add new test cases for date/time functions with evidence marks. (check-in: [64fa9e8c87] user: drh branch: trunk, size: 34441) | |
2022-01-21
| ||
18:57 | [e25773f06a] part of check-in [2f5dc7a9ee] Fix some of the new date/time function features to comply with the spec. Update requirement marks. (check-in: [2f5dc7a9ee] user: drh branch: trunk, size: 34359) | |
2021-12-23
| ||
00:16 | [ab8e01d928] part of check-in [c75ba4fa64] Reduce the size of the compiled binary by a couple of hundred bytes by using a thigher packing of a transformation table in date.c. Suggested by forum post 4f6efbb2a9. (check-in: [c75ba4fa64] user: drh branch: trunk, size: 34203) | |
2021-12-08
| ||
20:36 | [b49c12c756] part of check-in [db58b2def0] Clarity tweak for date.c (check-in: [db58b2def0] user: larrybr branch: trunk, size: 34205) | |
2021-11-29
| ||
17:23 | [d0f09f7924] part of check-in [559fdc0aa7] Add the unixepoch() function and the 'auto' and 'julianday' modifiers. (check-in: [559fdc0aa7] user: drh branch: unixepoch, size: 34174) | |
2021-10-05
| ||
18:59 | [fa928630fe] part of check-in [cddd3b382a] Fix harmless compiler warnings, mostly caused by prior efforts to get static analyzers to run without warnings. (check-in: [cddd3b382a] user: drh branch: trunk, size: 32588) | |
2021-10-03
| ||
00:12 | [467848d818] part of check-in [e548e9299d] Add the sqlite3ResultStrAccum() internal interface to simplify the the implementation of functions that return strings. (check-in: [e548e9299d] user: drh branch: trunk, size: 32574) | |
2021-03-16
| ||
18:41 | [e0632f3359] part of check-in [1734c332e7] Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f]. (check-in: [1734c332e7] user: drh branch: trunk, size: 33575) | |
2020-07-21
| ||
18:25 | [dace306a10] part of check-in [14eed318aa] Add the sqlite3Int64ToText() routine and use it to convert integers to text, as it is much faster than the generic text formatter. (check-in: [14eed318aa] user: drh branch: trunk, size: 33526) | |
2020-06-19
| ||
11:34 | [9f1d31ef1b] part of check-in [7bb08b1bfc] Refactoring various names. No changes in the resulting machine code. (check-in: [7bb08b1bfc] user: drh branch: trunk, size: 33538) | |
2020-03-28
| ||
12:01 | [b29b349d27] part of check-in [076658e5d2] MSVC does not allow constant expressions as initializers for constants with /fp:strict. (check-in: [076658e5d2] user: drh branch: trunk, size: 33544) | |
2020-01-17
| ||
16:47 | [6c408fdd2e] part of check-in [c9abf1bd2d] Improved rounding in the 'unixepoch' feature of the date and time functions. (check-in: [c9abf1bd2d] user: drh branch: trunk, size: 33622) | |
2019-06-07
| ||
22:26 | [e1d8ac7102] part of check-in [67a68af557] When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. (check-in: [67a68af557] user: drh branch: trunk, size: 33614) | |
2017-12-07
| ||
22:04 | [ebe1dc7c8a] part of check-in [95958b60f9] Fix typo in comment. No changes to code. (check-in: [95958b60f9] user: mistachkin branch: trunk, size: 33608) | |
2017-07-20
| ||
13:17 | [48f743d88b] part of check-in [22eda0985e] Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. (check-in: [22eda0985e] user: drh branch: index-on-date-func, size: 33608) | |
2017-07-19
| ||
19:48 | [921fb5957c] part of check-in [0a5e1c04d9] Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (check-in: [0a5e1c04d9] user: drh branch: index-on-date-func, size: 33637) | |
17:12 | [9d27aa270d] part of check-in [55791928f3] Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. (check-in: [55791928f3] user: drh branch: pure-date-functions, size: 34227) | |
2017-04-22
| ||
00:20 | [cc42a41c74] part of check-in [e39769f442] Fix an assertion fault found by OSSFuzz. (check-in: [e39769f442] user: drh branch: trunk, size: 33520) | |
2017-03-03
| ||
21:36 | [ee676e7694] part of check-in [4a04c48a31] Remove an redundant function call from the date/time function implementation. (check-in: [4a04c48a31] user: drh branch: trunk, size: 33485) | |
20:43 | [499343d9cd] 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: 33508) | |
2017-03-02
| ||
23:40 | [bb4db348be] 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: 33445) | |
2016-12-30
| ||
00:09 | [dc3f1391d9] part of check-in [f57952bac6] Encode a 64-bit integer literal in date.c as a constant expression so that it works on older compilers. Also fix a harmless compiler warning in vdbe.c. (check-in: [f57952bac6] user: drh branch: trunk, size: 33426) | |
2016-12-07
| ||
15:49 | [b48378aeac] part of check-in [f360818737] Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. (check-in: [f360818737] user: drh branch: trunk, size: 33049) | |
2016-12-05
| ||
20:16 | [57f23f5835] part of check-in [b4bc40d183] Fix a harmless redundant local variable declaration in the date/time function logic. (check-in: [b4bc40d183] user: drh branch: trunk, size: 33063) | |
2016-12-02
| ||
19:07 | [116097946b] part of check-in [6e144735ed] Simplify the date/time function logic for improved rebustness and also to decrease the size of the binary. (check-in: [6e144735ed] user: drh branch: trunk, size: 33070) | |
17:08 | [58d4275a87] part of check-in [768c9859b2] Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. (check-in: [768c9859b2] user: drh branch: trunk, size: 32154) | |
14:15 | [59fc29b41e] 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: 31719) | |
2016-11-30
| ||
04:07 | [206d0eb85c] part of check-in [1218005ab7] More improvements to boundary cases in the date/time functions, flowing out of branch coverage testing. (check-in: [1218005ab7] user: drh branch: trunk, size: 31580) | |
00:48 | [736c1f36c5] 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: 31504) | |
2016-11-29
| ||
20:39 | [53a4019b90] 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: 31165) | |
2016-08-02
| ||
20:42 | [95c9a8d007] part of check-in [e2f9919e34] Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. (check-in: [e2f9919e34] user: drh branch: trunk, size: 30718) | |
2016-04-12
| ||
16:11 | [1cc9fb516e] part of check-in [541c6da238] Add and adjust comments. (check-in: [541c6da238] user: mistachkin branch: winCeLocalTime, size: 30733) | |
2016-04-11
| ||
22:45 | [b258191513] part of check-in [b35bb928b2] Further refinements. (check-in: [b35bb928b2] user: mistachkin branch: winCeLocalTime, size: 30673) | |
2016-04-05
| ||
17:59 | [cd412cb2ad] part of check-in [00990020d0] Merge updates from trunk. (check-in: [00990020d0] user: mistachkin branch: winCeLocalTime, size: 30382) | |
2016-02-15
| ||
00:34 | [0b73e681c1] part of check-in [3201fbcc51] Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. (check-in: [3201fbcc51] user: drh branch: many-app-functions, size: 30382) | |
2016-02-05
| ||
13:38 | [ca17321bc1] part of check-in [0a802e96ab] Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. (check-in: [0a802e96ab] user: drh branch: oom-handling, size: 30557) | |
2016-01-23
| ||
01:54 | [6142d9e4d2] part of check-in [39759a5532] Cleanup localtime() support for Windows CE. (check-in: [39759a5532] user: mistachkin branch: winCeLocalTime, size: 30555) | |
2016-01-14
| ||
19:32 | [997651e3ee] part of check-in [b9159f42a5] Simplification to the ISO8610 parser in the imnplementation of date/time functions. (check-in: [b9159f42a5] user: drh branch: trunk, size: 30555) | |
2015-12-23
| ||
10:54 | [e4655393bb] 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: 29832) | |
2015-08-31
| ||
17:34 | [fb1c991720] part of check-in [c77554b5c4] Make the distinction between truly deterministic functions and date/time functions which only return the same answer for a single query. Only truly deterministic functions are allowed in indexes. Add new expression index test cases. (check-in: [c77554b5c4] user: drh branch: index-expr, size: 29643) | |
2015-07-15
| ||
18:04 | [8ec787fed4] part of check-in [b522c95ddc] Attempt to fix harmless warnings generated by GCC and Clang runtime analyzers. (check-in: [b522c95ddc] user: drh branch: trunk, size: 29635) | |
2015-01-10
| ||
16:49 | [e4d50b3283] part of check-in [9e92a5ed5a] Improvements to compile-time-option hygiene. Use "#if OPTION" instead of "#ifdef OPTION" in cases where that makes sense, so that -DOPTION=0 will work. Add the "Have-Not" configuration in releasetest.tcl which disables all of the "HAVE_component" compile-time options. (check-in: [9e92a5ed5a] user: drh branch: trunk, size: 29627) | |
2015-01-09
| ||
01:27 | [53cedb5416] part of check-in [fe57886331] Fix three crash problems discovered by afl-fuzz. Ticket [a59ae93ee990a55]. (check-in: [fe57886331] user: drh branch: trunk, size: 29725) | |
2014-11-07
| ||
13:24 | [93594514aa] part of check-in [94c564da4c] Fix harmless typos in comments. (check-in: [94c564da4c] user: drh branch: trunk, size: 29693) | |
2014-09-06
| ||
16:39 | [57a7f9ba9f] part of check-in [e62aab5e92] Fix typos in comments. No code changes. (check-in: [e62aab5e92] user: peter.d.reid branch: trunk, size: 29693) | |
2014-05-19
| ||
15:16 | [7535e8660c] part of check-in [17349a49d2] Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. (check-in: [17349a49d2] user: drh branch: safer-malloc, size: 29686) | |
2014-04-23
| ||
12:00 | [483fd9eeb7] part of check-in [2029a396dc] Enhancements to the date and time functions so that they optionally support a 5-digit year. Not sure we want to include this in trunk. Saved in a branch for future reference. (check-in: [2029a396dc] user: drh branch: five-digit-year, size: 30439) | |
2013-10-11
| ||
20:14 | [593c744b26] part of check-in [5e0d43ab55] Add requirements marks. No code changes. (check-in: [5e0d43ab55] user: drh branch: trunk, size: 29691) | |
2013-09-16
| ||
12:57 | [65196e95e6] 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: 29237) | |
2011-10-12
| ||
23:13 | [067a81c994] part of check-in [c96651dd6c] The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] (check-in: [c96651dd6c] user: drh branch: trunk, size: 29330) | |
2011-06-24
| ||
11:29 | [a3c6842bad] part of check-in [9b191bb4c7] Fix some harmless compiler warnings that were occurring with THREADSAFE=0. (check-in: [9b191bb4c7] user: drh branch: trunk, size: 29220) | |
2011-06-21
| ||
15:58 | [c223415ea9] part of check-in [1abce55a1e] Give the osLocaltime() function file scope in date.c. (check-in: [1abce55a1e] user: dan branch: branch-3.7.6, size: 29079) | |
15:54 | [d3c11de763] part of check-in [1577484595] Give the osLocaltime() function file scope in date.c. (check-in: [1577484595] user: drh branch: trunk, size: 29189) | |
15:38 | [e4df48782b] part of check-in [6b9877fa43] Initialize a variable introduced as part of the fix for [bd484a090c8077] in order to silence a compiler warning. (check-in: [6b9877fa43] user: dan branch: trunk, size: 29182) | |
15:34 | [1478fb55fa] part of check-in [2f5b37122b] Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. (check-in: [2f5b37122b] user: drh branch: branch-3.6.1, size: 27626) | |
15:01 | [8eb16dd5c0] part of check-in [176248095b] Rework the localtime logic yet again in order to make all branches reachable and to follow GNU standards for HAVE_LOCALTIME_R-type macros. Ticket [bd484a090c8077]. (check-in: [176248095b] user: drh branch: trunk, size: 29072) | |
14:35 | [2c5b336a05] part of check-in [5b68dae320] Simplifications to the localtime() interface. Fix the case where localtime_r() is available so that it works. Ticket [bd484a090c8077]. (check-in: [5b68dae320] user: drh branch: trunk, size: 28833) | |
13:46 | [193172e7a5] part of check-in [0e82175fd8] Change the error message returned when localtime_r() fails to "local time unavailable". Ticket [bd484a090c8077] (check-in: [0e82175fd8] user: dan branch: trunk, size: 29881) | |
12:53 | [f3711b130f] part of check-in [97e86ec6df] Fix an error made in the previous commit. The parameters to localtime_s() were accidentally reversed. Ticket [bd484a090c807]. (check-in: [97e86ec6df] user: dan branch: trunk, size: 29879) | |
12:47 | [1b23db7886] part of check-in [76ae8257ef] Return an error if localtime_r() fails within one of the date/time functions. Fix for [bd484a090c]. (check-in: [76ae8257ef] user: dan branch: trunk, size: 29879) | |
2011-04-23
| ||
15:54 | [0d63575d48] part of check-in [68240e75e8] Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. (check-in: [68240e75e8] user: dan branch: uri, size: 27797) | |
2010-09-30
| ||
00:50 | [1548fdac51] part of check-in [14eed3a0e0] Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. (check-in: [14eed3a0e0] user: drh branch: experimental, size: 27798) | |
2010-05-03
| ||
19:17 | [5dd8448a0b] part of check-in [e7ded46b5e] Fix a bug in the computation of the current time for the alternative CURRENT_TIMESTAMP functions used when SQLITE_OMIT_DATETIME is defined. (check-in: [e7ded46b5e] user: drh branch: trunk, size: 27866) | |
14:32 | [8a389e9529] part of check-in [ab77b3ae6d] Use VFS method xCurrentTimeInt64 instead of xCurrentTime when it is available. Provide an implementation of xCurrentTimeInt64 for os_unix.c. (check-in: [ab77b3ae6d] user: drh branch: trunk, size: 27867) | |
2010-01-12
| ||
19:28 | [485a4409a3] part of check-in [eb98265b59] Fix the implementation of CURRENT_TIMESTAME and CURRENT_DATE when SQLITE_OMIT_DATETIME_FUNCS is defined. (check-in: [eb98265b59] user: drh branch: trunk, size: 28080) | |
2009-11-10
| ||
01:30 | [a79c0a8f21] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 28080) | |
2009-09-22
| ||
13:25 | [657ff12ca0] part of check-in [216bcda7d2] Allow specific exclusion of localtime_s() usage on Windows. (check-in: [216bcda7d2] user: shane branch: trunk, size: 28136) | |
2009-09-10
| ||
20:23 | [6d93639371] part of check-in [f42ec993ac] Fixed some warnings and an assert in the WINCE code when compiling under MSVC. (check-in: [f42ec993ac] user: shane branch: trunk, size: 28116) | |
2009-05-03
| ||
20:23 | [ab5f713765] part of check-in [a612299092] Changes to facility full coverage testing of util.c. (CVS 6597) (check-in: [a612299092] user: drh branch: trunk, size: 28106) | |
2009-04-16
| ||
12:58 | [d327ec7bb2] 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: 28030) | |
2009-04-03
| ||
12:04 | [3e5c554b2f] part of check-in [c26f97bd85] Use integer rather than floating point compuations in converting from julian day number to unix-time to avoid round-off errors on Borland compilers. Ticket #3769. (CVS 6445) (check-in: [c26f97bd85] user: drh branch: trunk, size: 28020) | |
2009-04-01
| ||
20:44 | [e6263ed895] 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: 28017) | |
2009-02-04
| ||
03:59 | [0d804df3bb] part of check-in [5cef400023] Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) (check-in: [5cef400023] user: shane branch: trunk, size: 28017) | |
2009-01-30
| ||
17:27 | [870770dde3] 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: 27777) | |
2009-01-28
| ||
02:55 | [b4db68e6cd] part of check-in [90b42eba8e] Add testcase() macros for coverage in date.c. (CVS 6209) (check-in: [90b42eba8e] user: drh branch: trunk, size: 27570) | |
2009-01-20
| ||
16:53 | [6fd7a113e8] part of check-in [1041abd678] When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) (check-in: [1041abd678] user: danielk1977 branch: trunk, size: 27402) | |
2008-12-20
| ||
13:18 | [e010095d85] part of check-in [51b3bfc3b9] Do not use long long constants in code. Ticket #3547. (CVS 6048) (check-in: [51b3bfc3b9] user: drh branch: trunk, size: 27395) | |
2008-12-10
| ||
22:30 | [3dbac3eac2] part of check-in [715dcd52c1] Work to remove harmless MSVC compiler warnings. (CVS 6013) (check-in: [715dcd52c1] user: shane branch: trunk, size: 27387) | |
21:19 | [719afa5531] part of check-in [ea01d43788] Additional work at eliminating silly compiler warnings. (CVS 6010) (check-in: [ea01d43788] user: drh branch: trunk, size: 27389) | |
19:26 | [9a61564454] part of check-in [c872d55493] Never use strlen(). Use our own internal sqlite3Strlen30() which is guaranteed to never overflow an integer. Additional explicit casts to avoid nuisance warning messages. (CVS 6007) (check-in: [c872d55493] user: drh branch: trunk, size: 27367) | |
2008-12-09
| ||
04:59 | [80b158ab6d] part of check-in [5eb648a0b5] Removed some harmless compiler warnings and converted some "double" ops to "int" in date.c. (CVS 5997) (check-in: [5eb648a0b5] user: shane branch: trunk, size: 27266) | |
2008-11-19
| ||
09:05 | [88898ae96a] part of check-in [88134322c3] Changes to avoid "unused parameter" compiler warnings. (CVS 5921) (check-in: [88134322c3] user: danielk1977 branch: trunk, size: 26979) | |
2008-11-17
| ||
19:18 | [acae103fc6] part of check-in [8009220c36] Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) (check-in: [8009220c36] user: danielk1977 branch: trunk, size: 26838) | |
2008-10-13
| ||
15:35 | [6f4277fa56] part of check-in [c3f9164515] Fix the SQLITE_OMIT_DATETIME_FUNCS compile-time option so that it builds successfully. (CVS 5815) (check-in: [c3f9164515] user: drh branch: trunk, size: 26822) | |
2008-10-07
| ||
12:32 | [1b1fc801df] part of check-in [b03231323a] Do not use double unnecessarily in date+time functions. Ticket #3422. (CVS 5776) (check-in: [b03231323a] user: drh branch: trunk, size: 26810) | |
2008-09-03
| ||
17:11 | [5c092296c0] part of check-in [e333c3f4c3] Work around an issue with the WINSCW compiler. (CVS 5671) (check-in: [e333c3f4c3] user: drh branch: trunk, size: 26813) | |
2008-09-01
| ||
18:34 | [6609557446] part of check-in [573d92abb9] Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) (check-in: [573d92abb9] user: danielk1977 branch: trunk, size: 26811) | |
2008-08-21
| ||
20:21 | [2373f20a91] part of check-in [80d6a31cb3] Move date+time functions to start-time initialization. Additional start-time function cleanup. (CVS 5585) (check-in: [80d6a31cb3] user: drh branch: trunk, size: 26697) | |
2008-07-28
| ||
19:34 | [52a5481121] part of check-in [e48f9697e9] Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) (check-in: [e48f9697e9] user: drh branch: trunk, size: 26886) | |
2008-07-25
| ||
16:39 | [243677c51b] part of check-in [71486e93b2] Add an SQLITE_OMIT_LOCALTIME around the "utc" modifier in date/time functions. (CVS 5483) (check-in: [71486e93b2] user: drh branch: trunk, size: 26851) | |
2008-06-18
| ||
17:09 | [e841168e55] part of check-in [5059644c4b] Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234) (check-in: [5059644c4b] user: danielk1977 branch: trunk, size: 26815) | |
2008-06-15
| ||
02:51 | [bbc4114d1b] part of check-in [65fe7b62cf] Continuing work on the new memory allocation subsystem. Added routines for temporary memory allocation. Right the btree balance mechanism to only do one temporary allocation at a time. (CVS 5220) (check-in: [65fe7b62cf] user: drh branch: trunk, size: 26815) | |
2008-06-12
| ||
16:35 | [76a5ba9477] 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: 26816) | |
13:50 | [95d742c3fb] part of check-in [6ec4d7653b] Avoid unnecessary float->text->float conversions in date/time processing. This change necessary to reproduce the problem reported by BareFoot. (CVS 5213) (check-in: [6ec4d7653b] user: drh branch: trunk, size: 26455) | |
12:51 | [fd34fd6b95] part of check-in [12f3ba11e7] Add the ability to disable the "localtime" modifier in the date/time functions. This might be necessary for systems that do not support localtime_r() or localtime_s(). (CVS 5212) (check-in: [12f3ba11e7] user: drh branch: trunk, size: 26127) | |
2008-05-27
| ||
19:49 | [b305ced9f4] part of check-in [1518827e48] Updated to use localtime_s() in Windows build environments that support it. Ticket #3126. (CVS 5164) (check-in: [1518827e48] user: shane branch: trunk, size: 26027) | |
2008-03-20
| ||
14:03 | [e41ce4513f] part of check-in [60c77882b2] Initial implementation of per-connection limits and the sqlite3_limit() API. The sqllimits1.test script crashes. SQLITE_LIMIT_PAGE_COUNT and SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897) (check-in: [60c77882b2] user: drh branch: trunk, size: 25127) | |
2008-03-19
| ||
21:45 | [7b80383c47] part of check-in [54c55cae55] Add a new interface, sqlite3_context_db_handle(), that returns the database connection pointer for an application-defined function. (CVS 4889) (check-in: [54c55cae55] user: drh branch: trunk, size: 25081) | |
20:18 | [4c026b335c] part of check-in [73fbac7cf7] Use the xCurrentTime method of the default VFS instead of stdlib time() to get the current time when compiling with SQLITE_OMIT_DATETIME_FUNCS. (CVS 4887) (check-in: [73fbac7cf7] user: drh branch: trunk, size: 25066) | |
2008-02-21
| ||
20:40 | [187cad26ea] 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: 25103) | |
2008-01-17
| ||
22:27 | [8ce763c681] part of check-in [a676f949b6] Test coverage for date.c. (CVS 4722) (check-in: [a676f949b6] user: drh branch: trunk, size: 24968) | |
20:26 | [a5bf94263a] part of check-in [495fb41626] Improved test coverage in date.c. Report an error if a malloc fails within strftime(). (CVS 4721) (check-in: [495fb41626] user: drh branch: trunk, size: 25277) | |
2007-09-12
| ||
17:01 | [49c5a6d2de] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 25224) | |
2007-08-24
| ||
03:51 | [af235f38f5] part of check-in [3a68fcddfa] The win32 driver compiles but does not yet work well. Many bugs fixed. (CVS 4282) (check-in: [3a68fcddfa] user: drh branch: trunk, size: 25202) | |
2007-08-21
| ||
19:33 | [a80b33f6e7] part of check-in [9287276191] The sqlite3_value object now carries an sqlite3* pointer to use for recording malloc failures. This eliminates the need to pass sqlite3* pointers into many internal interfaces. Also added more mutexing. (CVS 4263) (check-in: [9287276191] user: drh branch: trunk, size: 25188) | |
10:44 | [70a5af1944] part of check-in [fbbd5bda54] Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) (check-in: [fbbd5bda54] user: drh branch: trunk, size: 25197) | |
2007-08-18
| ||
10:59 | [8c37dbbabc] part of check-in [a258c4ec24] Further progress on migration to sqlite3_vfs. (CVS 4242) (check-in: [a258c4ec24] user: danielk1977 branch: trunk, size: 25221) | |
2007-08-16
| ||
10:09 | [c44aa498ee] part of check-in [77b1671351] More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) (check-in: [77b1671351] user: danielk1977 branch: trunk, size: 24871) | |
04:30 | [6c6ae019e7] part of check-in [deb7ecd65f] Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) (check-in: [deb7ecd65f] user: drh branch: trunk, size: 24851) | |
2007-05-08
| ||
21:56 | [6049db7d5a] part of check-in [03349ec0be] Remove a keyword from the header comment in date.c (CVS 3961) (check-in: [03349ec0be] user: drh branch: trunk, size: 24847) | |
15:15 | [263ef5b81b] part of check-in [17c4235c49] Introduce the (experimental) sqlite3_result_error_toobig() API that function implementations can use to signal SQLite that the function result is too big to represent. (CVS 3949) (check-in: [17c4235c49] user: drh branch: trunk, size: 24860) | |
2007-05-04
| ||
13:15 | [c34a9c86ff] 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: 24765) | |
2007-04-25
| ||
18:23 | [94a6777df1] part of check-in [9cb0ed6ee9] Fix segfaults that can occur if a malloc failure happens just before a built-in function calls sqlite3_value_text(). (CVS 3874) (check-in: [9cb0ed6ee9] user: drh branch: trunk, size: 24498) | |
2007-04-06
| ||
02:32 | [74b76691bd] 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: 24526) | |
2007-03-29
| ||
17:57 | [c4930ef6af] 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: 24528) | |
2007-01-08
| ||
16:20 | [3f080b6f46] part of check-in [47fee16ba9] Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) (check-in: [47fee16ba9] user: drh branch: version_2, size: 21216) | |
16:19 | [393c73fc02] part of check-in [d49ddc5ff0] Fix another round-off problem in strftime(). Ticket #2153. (CVS 3574) (check-in: [d49ddc5ff0] user: drh branch: trunk, size: 24528) | |
13:43 | [93658710c6] part of check-in [e6a18741a4] Fix a round-off error in the %W conversion of strftime(). Ticket #2150. (CVS 3572) (check-in: [e6a18741a4] user: drh branch: version_2, size: 21222) | |
13:07 | [bc0828d380] 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: 24534) | |
2006-09-25
| ||
18:05 | [9602457c49] part of check-in [433dac1f29] CVS malfunctioned on the previous check-in. Make sure the revision to date.c was received. Ticket #1991. (CVS 3444) (check-in: [433dac1f29] user: drh branch: trunk, size: 24528) | |
18:01 | [5e470f013b] part of check-in [bf4608406a] Fix a round-off problem in the %f conversion of strftime(). Ticket #1991. (CVS 3443) (check-in: [bf4608406a] user: drh branch: trunk, size: 24527) | |
2006-09-08
| ||
12:49 | [d551902356] part of check-in [862302eaae] Add HAVE_GMTIME_R and HAVE_LOCALTIME_R flags and use them if defined. Unable to modify the configure script to test for gmtime_r and localtime_r, however, because on my SuSE 10.2 system, autoconf generates a configure script that does not work. Bummer. Ticket #1906 (CVS 3397) (check-in: [862302eaae] user: drh branch: trunk, size: 24517) | |
12:27 | [bbfc2db2b7] 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: 24052) | |
2006-01-31
| ||
20:49 | [cd2bd5d1eb] part of check-in [a088eb6d6e] Patches to support linux on embedded platforms. (CVS 3049) (check-in: [a088eb6d6e] user: drh branch: trunk, size: 24031) | |
2006-01-24
| ||
12:09 | [c70a4f88e4] part of check-in [d86f18a427] Rename some variables to avoid hiding others. Also add "static" to two function signatures that were missing it. (CVS 3024) (check-in: [d86f18a427] user: danielk1977 branch: trunk, size: 24039) | |
2006-01-17
| ||
13:21 | [2f148728b5] part of check-in [0505405fb9] Various fixes that allow the malloc() failure tests to pass again. (CVS 2963) (check-in: [0505405fb9] user: danielk1977 branch: trunk, size: 24027) | |
2006-01-15
| ||
00:13 | [5f5850c6b5] part of check-in [03c422ecb5] Documentation updates. Fix to date.c. But most importantly: database connections are now allowed to change threads as long as they are not holding a lock. (CVS 2944) (check-in: [03c422ecb5] user: drh branch: trunk, size: 24031) | |
2006-01-13
| ||
01:17 | [5b86bc4175] part of check-in [94eac140f2] Terminate the va_start in the getDigits function of date.c. (CVS 2931) (check-in: [94eac140f2] user: drh branch: trunk, size: 24000) | |
2006-01-09
| ||
00:18 | [a927bdbb51] 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: 23986) | |
2006-01-06
| ||
14:32 | [9a1fe548e3] part of check-in [2529c2e11f] Change the OS interface layer to use traditional direct function call implementations instead of the more complicated virtual function table. Omit the asynchronous I/O demo. (CVS 2870) (check-in: [2529c2e11f] user: drh branch: trunk, size: 23986) | |
2005-12-09
| ||
20:02 | [bb079317bf] part of check-in [83a5915155] Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: [83a5915155] user: drh branch: trunk, size: 23996) | |
2005-11-30
| ||
03:20 | [8bc8d084a1] part of check-in [bd8740d1ae] Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) (check-in: [bd8740d1ae] user: drh branch: trunk, size: 23969) | |
2005-06-25
| ||
18:42 | [7444b0900a] part of check-in [17631785f9] Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: [17631785f9] user: drh branch: trunk, size: 23959) | |
2005-03-21
| ||
00:43 | [2134ef4388] 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: 24056) | |
2005-01-15
| ||
01:52 | [f3d1f5cd15] part of check-in [92f9d2b2f4] Test coverage improvements. (CVS 2215) (check-in: [92f9d2b2f4] user: drh branch: trunk, size: 24036) | |
2004-11-14
| ||
21:56 | [65536e7ea0] part of check-in [98c7a55478] The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) (check-in: [98c7a55478] user: drh branch: trunk, size: 24071) | |
2004-11-11
| ||
01:50 | [4fd4e90b38] part of check-in [c85f13f8f2] Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) (check-in: [c85f13f8f2] user: danielk1977 branch: trunk, size: 24118) | |
2004-11-10
| ||
11:55 | [21413a0fc3] part of check-in [8e5c2e5df8] Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) (check-in: [8e5c2e5df8] user: danielk1977 branch: trunk, size: 24124) | |
2004-11-09
| ||
16:13 | [fcbade1333] part of check-in [f81b9c1c02] Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) (check-in: [f81b9c1c02] user: danielk1977 branch: trunk, size: 24108) | |
12:44 | [dbf15c130b] part of check-in [0d27c8ff48] Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: [0d27c8ff48] user: danielk1977 branch: trunk, size: 22634) | |
2004-10-06
| ||
15:41 | [34bdb0082d] part of check-in [d790c84c5a] Convert many constants to have type "const". (CVS 2006) (check-in: [d790c84c5a] user: drh branch: trunk, size: 21364) | |
2004-10-01
| ||
02:00 | [93927e2d1f] part of check-in [8972c004dc] Use type i64 instead of off_t for file offsets since off_t is giving portability problems. Ticket #924. (CVS 1992) (check-in: [8972c004dc] user: drh branch: trunk, size: 21358) | |
2004-09-06
| ||
17:24 | [eb8d5fa1a6] part of check-in [3ddf5a9d1c] Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 connection now *must* be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) (check-in: [3ddf5a9d1c] user: drh branch: trunk, size: 21358) | |
2004-08-17
| ||
10:42 | [edff4aa851] part of check-in [9af1d4d145] Fix a typo in a comment. (CVS 1889) (check-in: [9af1d4d145] user: drh branch: trunk, size: 21357) | |
2004-08-08
| ||
20:22 | [a164e3a58f] part of check-in [b065973898] Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) (check-in: [b065973898] user: drh branch: trunk, size: 21357) | |
2004-07-20
| ||
00:40 | [54befeafe3] part of check-in [28c01d2ac7] Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1829) (check-in: [28c01d2ac7] user: drh branch: version_2, size: 21216) | |
00:39 | [e1bb384a78] part of check-in [4e2ad572ea] Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1828) (check-in: [4e2ad572ea] user: drh branch: trunk, size: 21320) | |
2004-07-18
| ||
22:25 | [6ccb9336f1] 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: 21216) | |
22:22 | [d42ea73a0b] 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: 21320) | |
2004-06-19
| ||
08:18 | [b3e8b2bef1] part of check-in [728d57ff55] Remove the iCollate argument from sqlite3_create_function() (CVS 1632) (check-in: [728d57ff55] user: danielk1977 branch: trunk, size: 21169) | |
2004-06-12
| ||
09:25 | [65b483caeb] part of check-in [5903f53828] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f53828] user: danielk1977 branch: trunk, size: 21172) | |
00:42 | [2d193dbe7c] part of check-in [9b84f2f488] Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) (check-in: [9b84f2f488] user: danielk1977 branch: trunk, size: 21102) | |
2004-05-31
| ||
18:51 | [8e6fa31733] part of check-in [adf7e29ff6] Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) (check-in: [adf7e29ff6] user: drh branch: trunk, size: 21092) | |
2004-05-26
| ||
23:25 | [0eb922af5c] part of check-in [bba6684d50] Refactoring of the vdbe Mem functions and the APIs that deal with them. The code will not compile in its current state. (CVS 1465) (check-in: [bba6684d50] user: drh branch: trunk, size: 21094) | |
16:54 | [37bb5784da] part of check-in [36e0316259] Remove dataType and includeTypes flags from function definitions. Added new P3_FUNCDEF type for P3 arguments on opcodes. Fixes to several user functions. 28 tests fail now. (CVS 1464) (check-in: [36e0316259] user: drh branch: trunk, size: 21094) | |
06:18 | [1a6a72549e] part of check-in [0317bef4b0] Use the new form of the sqlite3_create_function() API. (CVS 1460) (check-in: [0317bef4b0] user: danielk1977 branch: trunk, size: 21267) | |
2004-05-25
| ||
12:05 | [098aee0a00] part of check-in [8f6b20c293] Change a couple of symbol names for the new user function API. (CVS 1454) (check-in: [8f6b20c293] user: danielk1977 branch: trunk, size: 21258) | |
11:47 | [b754dc0e1a] part of check-in [4eccae03b4] Use the new API for returning values and errors from user functions. (CVS 1453) (check-in: [4eccae03b4] user: danielk1977 branch: trunk, size: 21234) | |
2004-05-24
| ||
12:39 | [64fd7169c7] part of check-in [1e47d7384d] Non-aggregate SQL functions use sqlite_value* instead of const char * for argument values. (CVS 1449) (check-in: [1e47d7384d] user: danielk1977 branch: trunk, size: 21250) | |
07:04 | [fd6a464984] part of check-in [b7155db2b1] Have the vdbe handle strings in the same encoding as the database. (CVS 1445) (check-in: [b7155db2b1] user: danielk1977 branch: trunk, size: 21094) | |
2004-05-14
| ||
11:00 | [0eb0a89960] part of check-in [dbfe6e9316] Implement type affinity for table and index records (CVS 1375) (check-in: [dbfe6e9316] user: danielk1977 branch: trunk, size: 21083) | |
2004-05-10
| ||
10:34 | [1564caa119] part of check-in [ba2ba24263] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1337) (check-in: [ba2ba24263] user: danielk1977 branch: trunk, size: 21080) | |
2004-05-08
| ||
08:23 | [ca325e0752] part of check-in [8af6474c49] Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: [8af6474c49] user: danielk1977 branch: trunk, size: 21073) | |
2004-02-29
| ||
01:08 | [f055419d60] 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: 21053) | |
00:50 | [33a5267827] part of check-in [e20d51f94e] Try again to get the HH:MM:SS modifier change right... (CVS 1279) (check-in: [e20d51f94e] user: drh branch: trunk, size: 21054) | |
00:48 | [1eaa501433] part of check-in [248b550090] Fix a bug in the HH:MM:SS modifier change that was just checked in. (CVS 1278) (check-in: [248b550090] user: drh branch: trunk, size: 21014) | |
00:40 | [6cb6954302] part of check-in [559002a52f] Allow time modifiers of the form HH:MM:SS.SSS with an option "+" or "-" prefix. The specified amount of time is added into the date-time begin modified. (CVS 1277) (check-in: [559002a52f] user: drh branch: trunk, size: 20964) | |
2004-02-22
| ||
17:49 | [3025642cee] part of check-in [9b3bcde153] Code cleanup in the date and time functions. (CVS 1263) (check-in: [9b3bcde153] user: drh branch: trunk, size: 20238) | |
2004-02-21
| ||
03:28 | [6120c591cd] 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: 20173) | |
2004-02-10
| ||
13:19 | [c9d2bfd40b] part of check-in [d0624d2577] Fix for ticket #603. (CVS 1220) (check-in: [d0624d2577] user: drh branch: trunk, size: 20186) | |
2004-01-17
| ||
01:16 | [c6b7e3fa53] part of check-in [ed6bd2eb39] Do not use strcpy() on overlapping buffers. (CVS 1187) (check-in: [ed6bd2eb39] user: drh branch: trunk, size: 20184) | |
2004-01-08
| ||
02:17 | [bb89fdb9c8] part of check-in [34a6b7416c] Remove unused code and tighten existing code to make the library a little smaller. (CVS 1168) (check-in: [34a6b7416c] user: drh branch: trunk, size: 20215) | |
2004-01-07
| ||
03:29 | [eef0ccd9d0] 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: 20561) | |
2003-12-31
| ||
17:25 | [13775c2ded] part of check-in [458cfa5ba8] Fix for ticket #542. (CVS 1151) (check-in: [458cfa5ba8] user: drh branch: trunk, size: 20535) | |
2003-12-24
| ||
01:41 | [d637786792] part of check-in [9392c51450] minor edits for new date.c with mingw/msys on Windows (CVS 1148) (check-in: [9392c51450] user: dougcurrie branch: trunk, size: 20531) | |
2003-12-23
| ||
16:34 | [a69da8995e] 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: 20524) | |
16:22 | [1e3318d845] part of check-in [8482b8c447] Add localtime<-->UTC conversions to the date functions. (CVS 1146) (check-in: [8482b8c447] user: drh branch: trunk, size: 20482) | |
02:17 | [ec36ce6f04] part of check-in [4d9edbc50f] Use a built-in atof() function instead of the one from the library to avoid problems with locale. Ticket #305. (CVS 1144) (check-in: [4d9edbc50f] user: drh branch: trunk, size: 18681) | |
2003-11-01
| ||
01:53 | Added: [acb75ff784] 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: 18675) | |