/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of src/date.c

2019-06-07
22:26
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]. file: [e1d8ac71] check-in: [67a68af5] user: drh branch: trunk, size: 33614
2017-12-07
22:04
Fix typo in comment. No changes to code. file: [ebe1dc7c] check-in: [95958b60] user: mistachkin branch: trunk, size: 33608
2017-07-20
13:17
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. file: [48f743d8] check-in: [22eda098] user: drh branch: index-on-date-func, size: 33608
2017-07-19
19:48
Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. file: [921fb595] check-in: [0a5e1c04] user: drh branch: index-on-date-func, size: 33637
17:12
Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. file: [9d27aa27] check-in: [55791928] user: drh branch: pure-date-functions, size: 34227
2017-04-22
00:20
Fix an assertion fault found by OSSFuzz. file: [cc42a41c] check-in: [e39769f4] user: drh branch: trunk, size: 33520
2017-03-03
21:36
Remove an redundant function call from the date/time function implementation. file: [ee676e76] check-in: [4a04c48a] user: drh branch: trunk, size: 33485
20:43
Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1]. file: [499343d9] check-in: [8831f439] user: drh branch: trunk, size: 33508
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: [bb4db348] check-in: [081dbcfb] user: drh branch: trunk, size: 33445
2016-12-30
00:09
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. file: [dc3f1391] check-in: [f57952ba] user: drh branch: trunk, size: 33426
2016-12-07
15:49
Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. file: [b48378ae] check-in: [f3608187] user: drh branch: trunk, size: 33049
2016-12-05
20:16
Fix a harmless redundant local variable declaration in the date/time function logic. file: [57f23f58] check-in: [b4bc40d1] user: drh branch: trunk, size: 33063
2016-12-02
19:07
Simplify the date/time function logic for improved rebustness and also to decrease the size of the binary. file: [11609794] check-in: [6e144735] user: drh branch: trunk, size: 33070
17:08
Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. file: [58d4275a] check-in: [768c9859] user: drh branch: trunk, size: 32154
14:15
Fix a potential integer overflow during out-of-bound date computations. file: [59fc29b4] check-in: [3c58b173] user: drh branch: date-overflow-fix, size: 31719
2016-11-30
04:07
More improvements to boundary cases in the date/time functions, flowing out of branch coverage testing. file: [206d0eb8] check-in: [1218005a] user: drh branch: trunk, size: 31580
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: [736c1f36] check-in: [dc453b34] user: drh branch: trunk, size: 31504
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: [53a4019b] check-in: [d410a839] user: drh branch: trunk, size: 31165
2016-08-02
20:42
Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. file: [95c9a8d0] check-in: [e2f9919e] user: drh branch: trunk, size: 30718
2016-04-12
16:11
Add and adjust comments. file: [1cc9fb51] check-in: [541c6da2] user: mistachkin branch: winCeLocalTime, size: 30733
2016-04-11
22:45
Further refinements. file: [b2581915] check-in: [b35bb928] user: mistachkin branch: winCeLocalTime, size: 30673
2016-04-05
17:59
Merge updates from trunk. file: [cd412cb2] check-in: [00990020] user: mistachkin branch: winCeLocalTime, size: 30382
2016-02-15
00:34
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. file: [0b73e681] check-in: [3201fbcc] user: drh branch: many-app-functions, size: 30382
2016-02-05
13:38
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. file: [ca17321b] check-in: [0a802e96] user: drh branch: oom-handling, size: 30557
2016-01-23
01:54
Cleanup localtime() support for Windows CE. file: [6142d9e4] check-in: [39759a55] user: mistachkin branch: winCeLocalTime, size: 30555
2016-01-14
19:32
Simplification to the ISO8610 parser in the imnplementation of date/time functions. file: [997651e3] check-in: [b9159f42] user: drh branch: trunk, size: 30555
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: [e4655393] check-in: [b910a3d5] user: drh branch: trunk, size: 29832
2015-08-31
17:34
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. file: [fb1c9917] check-in: [c77554b5] user: drh branch: index-expr, size: 29643
2015-07-15
18:04
Attempt to fix harmless warnings generated by GCC and Clang runtime analyzers. file: [8ec787fe] check-in: [b522c95d] user: drh branch: trunk, size: 29635
2015-01-10
16:49
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. file: [e4d50b32] check-in: [9e92a5ed] user: drh branch: trunk, size: 29627
2015-01-09
01:27
Fix three crash problems discovered by afl-fuzz. Ticket [a59ae93ee990a55]. file: [53cedb54] check-in: [fe578863] user: drh branch: trunk, size: 29725
2014-11-07
13:24
Fix harmless typos in comments. file: [93594514] check-in: [94c564da] user: drh branch: trunk, size: 29693
2014-09-06
16:39
Fix typos in comments. No code changes. file: [57a7f9ba] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 29693
2014-05-19
15:16
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. file: [7535e866] check-in: [17349a49] user: drh branch: safer-malloc, size: 29686
2014-04-23
12:00
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. file: [483fd9ee] check-in: [2029a396] user: drh branch: five-digit-year, size: 30439
2013-10-11
20:14
Add requirements marks. No code changes. file: [593c744b] check-in: [5e0d43ab] user: drh branch: trunk, size: 29691
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: [65196e95] check-in: [daf6ba41] user: drh branch: trunk, size: 29237
2011-10-12
23:13
The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] file: [067a81c9] check-in: [c96651dd] user: drh branch: trunk, size: 29330
2011-06-24
11:29
Fix some harmless compiler warnings that were occurring with THREADSAFE=0. file: [a3c6842b] check-in: [9b191bb4] user: drh branch: trunk, size: 29220
2011-06-21
15:58
Give the osLocaltime() function file scope in date.c. file: [c223415e] check-in: [1abce55a] user: dan branch: branch-3.7.6, size: 29079
15:54
Give the osLocaltime() function file scope in date.c. file: [d3c11de7] check-in: [15774845] user: drh branch: trunk, size: 29189
15:38
Initialize a variable introduced as part of the fix for [bd484a090c8077] in order to silence a compiler warning. file: [e4df4878] check-in: [6b9877fa] user: dan branch: trunk, size: 29182
15:34
Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. file: [1478fb55] check-in: [2f5b3712] user: drh branch: branch-3.6.1, size: 27626
15:01
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]. file: [8eb16dd5] check-in: [17624809] user: drh branch: trunk, size: 29072
14:35
Simplifications to the localtime() interface. Fix the case where localtime_r() is available so that it works. Ticket [bd484a090c8077]. file: [2c5b336a] check-in: [5b68dae3] user: drh branch: trunk, size: 28833
13:46
Change the error message returned when localtime_r() fails to "local time unavailable". Ticket [bd484a090c8077] file: [193172e7] check-in: [0e82175f] user: dan branch: trunk, size: 29881
12:53
Fix an error made in the previous commit. The parameters to localtime_s() were accidentally reversed. Ticket [bd484a090c807]. file: [f3711b13] check-in: [97e86ec6] user: dan branch: trunk, size: 29879
12:47
Return an error if localtime_r() fails within one of the date/time functions. Fix for [bd484a090c]. file: [1b23db78] check-in: [76ae8257] user: dan branch: trunk, size: 29879
2011-04-23
15:54
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. file: [0d63575d] check-in: [68240e75] user: dan branch: uri, size: 27797
2010-09-30
00:50
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. file: [1548fdac] check-in: [14eed3a0] user: drh branch: experimental, size: 27798
2010-05-03
19:17
Fix a bug in the computation of the current time for the alternative CURRENT_TIMESTAMP functions used when SQLITE_OMIT_DATETIME is defined. file: [5dd8448a] check-in: [e7ded46b] user: drh branch: trunk, size: 27866
14:32
Use VFS method xCurrentTimeInt64 instead of xCurrentTime when it is available. Provide an implementation of xCurrentTimeInt64 for os_unix.c. file: [8a389e95] check-in: [ab77b3ae] user: drh branch: trunk, size: 27867
2010-01-12
19:28
Fix the implementation of CURRENT_TIMESTAME and CURRENT_DATE when SQLITE_OMIT_DATETIME_FUNCS is defined. file: [485a4409] check-in: [eb98265b] user: drh branch: trunk, size: 28080
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [a79c0a8f] check-in: [f6c045f6] user: drh branch: trunk, size: 28080
2009-09-22
13:25
Allow specific exclusion of localtime_s() usage on Windows. file: [657ff12c] check-in: [216bcda7] user: shane branch: trunk, size: 28136
2009-09-10
20:23
Fixed some warnings and an assert in the WINCE code when compiling under MSVC. file: [6d936393] check-in: [f42ec993] user: shane branch: trunk, size: 28116
2009-05-03
20:23
Changes to facility full coverage testing of util.c. (CVS 6597) file: [ab5f7137] check-in: [a6122990] user: drh branch: trunk, size: 28106
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: [d327ec7b] check-in: [e6e036b3] user: drh branch: trunk, size: 28030
2009-04-03
12:04
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) file: [3e5c554b] check-in: [c26f97bd] user: drh branch: trunk, size: 28020
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: [e6263ed8] check-in: [a95b843a] user: drh branch: trunk, size: 28017
2009-02-04
03:59
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) file: [0d804df3] check-in: [5cef4000] user: shane branch: trunk, size: 28017
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: [870770dd] check-in: [86be908c] user: drh branch: trunk, size: 27777
2009-01-28
02:55
Add testcase() macros for coverage in date.c. (CVS 6209) file: [b4db68e6] check-in: [90b42eba] user: drh branch: trunk, size: 27570
2009-01-20
16:53
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) file: [6fd7a113] check-in: [1041abd6] user: danielk1977 branch: trunk, size: 27402
2008-12-20
13:18
Do not use long long constants in code. Ticket #3547. (CVS 6048) file: [e010095d] check-in: [51b3bfc3] user: drh branch: trunk, size: 27395
2008-12-10
22:30
Work to remove harmless MSVC compiler warnings. (CVS 6013) file: [3dbac3ea] check-in: [715dcd52] user: shane branch: trunk, size: 27387
21:19
Additional work at eliminating silly compiler warnings. (CVS 6010) file: [719afa55] check-in: [ea01d437] user: drh branch: trunk, size: 27389
19:26
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) file: [9a615644] check-in: [c872d554] user: drh branch: trunk, size: 27367
2008-12-09
04:59
Removed some harmless compiler warnings and converted some "double" ops to "int" in date.c. (CVS 5997) file: [80b158ab] check-in: [5eb648a0] user: shane branch: trunk, size: 27266
2008-11-19
09:05
Changes to avoid "unused parameter" compiler warnings. (CVS 5921) file: [88898ae9] check-in: [88134322] user: danielk1977 branch: trunk, size: 26979
2008-11-17
19:18
Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) file: [acae103f] check-in: [8009220c] user: danielk1977 branch: trunk, size: 26838
2008-10-13
15:35
Fix the SQLITE_OMIT_DATETIME_FUNCS compile-time option so that it builds successfully. (CVS 5815) file: [6f4277fa] check-in: [c3f91645] user: drh branch: trunk, size: 26822
2008-10-07
12:32
Do not use double unnecessarily in date+time functions. Ticket #3422. (CVS 5776) file: [1b1fc801] check-in: [b0323132] user: drh branch: trunk, size: 26810
2008-09-03
17:11
Work around an issue with the WINSCW compiler. (CVS 5671) file: [5c092296] check-in: [e333c3f4] user: drh branch: trunk, size: 26813
2008-09-01
18:34
Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) file: [66095574] check-in: [573d92ab] user: danielk1977 branch: trunk, size: 26811
2008-08-21
20:21
Move date+time functions to start-time initialization. Additional start-time function cleanup. (CVS 5585) file: [2373f20a] check-in: [80d6a31c] user: drh branch: trunk, size: 26697
2008-07-28
19:34
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) file: [52a54811] check-in: [e48f9697] user: drh branch: trunk, size: 26886
2008-07-25
16:39
Add an SQLITE_OMIT_LOCALTIME around the "utc" modifier in date/time functions. (CVS 5483) file: [243677c5] check-in: [71486e93] user: drh branch: trunk, size: 26851
2008-06-18
17:09
Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234) file: [e841168e] check-in: [5059644c] user: danielk1977 branch: trunk, size: 26815
2008-06-15
02:51
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) file: [bbc4114d] check-in: [65fe7b62] user: drh branch: trunk, size: 26815
2008-06-12
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: [76a5ba94] check-in: [ed35f8a9] user: drh branch: trunk, size: 26816
13:50
Avoid unnecessary float->text->float conversions in date/time processing. This change necessary to reproduce the problem reported by BareFoot. (CVS 5213) file: [95d742c3] check-in: [6ec4d765] user: drh branch: trunk, size: 26455
12:51
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) file: [fd34fd6b] check-in: [12f3ba11] user: drh branch: trunk, size: 26127
2008-05-27
19:49
Updated to use localtime_s() in Windows build environments that support it. Ticket #3126. (CVS 5164) file: [b305ced9] check-in: [1518827e] user: shane branch: trunk, size: 26027
2008-03-20
14:03
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) file: [e41ce451] check-in: [60c77882] user: drh branch: trunk, size: 25127
2008-03-19
21:45
Add a new interface, sqlite3_context_db_handle(), that returns the database connection pointer for an application-defined function. (CVS 4889) file: [7b80383c] check-in: [54c55cae] user: drh branch: trunk, size: 25081
20:18
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) file: [4c026b33] check-in: [73fbac7c] user: drh branch: trunk, size: 25066
2008-02-21
20:40
Accept "Z" as the zulu timezone at the end of date strings. (CVS 4805) file: [187cad26] check-in: [4c9a7b42] user: drh branch: trunk, size: 25103
2008-01-17
22:27
Test coverage for date.c. (CVS 4722) file: [8ce763c6] check-in: [a676f949] user: drh branch: trunk, size: 24968
20:26
Improved test coverage in date.c. Report an error if a malloc fails within strftime(). (CVS 4721) file: [a5bf9426] check-in: [495fb416] user: drh branch: trunk, size: 25277
2007-09-12
17:01
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [49c5a6d2] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 25224
2007-08-24
03:51
The win32 driver compiles but does not yet work well. Many bugs fixed. (CVS 4282) file: [af235f38] check-in: [3a68fcdd] user: drh branch: trunk, size: 25202
2007-08-21
19:33
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) file: [a80b33f6] check-in: [92872761] user: drh branch: trunk, size: 25188
10:44
Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) file: [70a5af19] check-in: [fbbd5bda] user: drh branch: trunk, size: 25197
2007-08-18
10:59
Further progress on migration to sqlite3_vfs. (CVS 4242) file: [8c37dbba] check-in: [a258c4ec] user: danielk1977 branch: trunk, size: 25221
2007-08-16
10:09
More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [c44aa498] check-in: [77b16713] user: danielk1977 branch: trunk, size: 24871
04:30
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) file: [6c6ae019] check-in: [deb7ecd6] user: drh branch: trunk, size: 24851
2007-05-08
21:56
Remove a keyword from the header comment in date.c (CVS 3961) file: [6049db7d] check-in: [03349ec0] user: drh branch: trunk, size: 24847
15:15
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) file: [263ef5b8] check-in: [17c4235c] user: drh branch: trunk, size: 24860
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: [c34a9c86] check-in: [ba4845b3] user: drh branch: trunk, size: 24765
2007-04-25
18:23
Fix segfaults that can occur if a malloc failure happens just before a built-in function calls sqlite3_value_text(). (CVS 3874) file: [94a6777d] check-in: [9cb0ed6e] user: drh branch: trunk, size: 24498
2007-04-06
02:32
Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) file: [74b76691] check-in: [a776d93c] user: drh branch: trunk, size: 24526
2007-03-29
17:57
Make sure the strftime() date conversions put in leading zeros correctly. Ticket #2276. (CVS 3749) file: [c4930ef6] check-in: [e853067e] user: drh branch: trunk, size: 24528
2007-01-08
16:20
Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) file: [3f080b6f] check-in: [47fee16b] user: drh branch: version_2, size: 21216
16:19
Fix another round-off problem in strftime(). Ticket #2153. (CVS 3574) file: [393c73fc] check-in: [d49ddc5f] user: drh branch: trunk, size: 24528
13:43
Fix a round-off error in the %W conversion of strftime(). Ticket #2150. (CVS 3572) file: [93658710] check-in: [e6a18741] user: drh branch: version_2, size: 21222
13:07
Fix a round-off error in the %W and %j conversions of the strftime() function. Ticket #2150. (CVS 3570) file: [bc0828d3] check-in: [52067937] user: drh branch: trunk, size: 24534
2006-09-25
18:05
CVS malfunctioned on the previous check-in. Make sure the revision to date.c was received. Ticket #1991. (CVS 3444) file: [9602457c] check-in: [433dac1f] user: drh branch: trunk, size: 24528
18:01
Fix a round-off problem in the %f conversion of strftime(). Ticket #1991. (CVS 3443) file: [5e470f01] check-in: [bf460840] user: drh branch: trunk, size: 24527
2006-09-08
12:49
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) file: [d5519023] check-in: [862302ea] user: drh branch: trunk, size: 24517
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: [bbfc2db2] check-in: [c81eaa0d] user: drh branch: trunk, size: 24052
2006-01-31
20:49
Patches to support linux on embedded platforms. (CVS 3049) file: [cd2bd5d1] check-in: [a088eb6d] user: drh branch: trunk, size: 24031
2006-01-24
12:09
Rename some variables to avoid hiding others. Also add "static" to two function signatures that were missing it. (CVS 3024) file: [c70a4f88] check-in: [d86f18a4] user: danielk1977 branch: trunk, size: 24039
2006-01-17
13:21
Various fixes that allow the malloc() failure tests to pass again. (CVS 2963) file: [2f148728] check-in: [0505405f] user: danielk1977 branch: trunk, size: 24027
2006-01-15
00:13
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) file: [5f5850c6] check-in: [03c422ec] user: drh branch: trunk, size: 24031
2006-01-13
01:17
Terminate the va_start in the getDigits function of date.c. (CVS 2931) file: [5b86bc41] check-in: [94eac140] user: drh branch: trunk, size: 24000
2006-01-09
00:18
Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) file: [a927bdbb] check-in: [94c87b70] user: drh branch: trunk, size: 23986
2006-01-06
14:32
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) file: [9a1fe548] check-in: [2529c2e1] user: drh branch: trunk, size: 23986
2005-12-09
20:02
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [bb079317] check-in: [83a59151] user: drh branch: trunk, size: 23996
2005-11-30
03:20
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) file: [8bc8d084] check-in: [bd8740d1] user: drh branch: trunk, size: 23969
2005-06-25
18:42
Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) file: [7444b090] check-in: [17631785] user: drh branch: trunk, size: 23959
2005-03-21
00:43
Allow the character "T" between date and time in ISO-8601 date/time formats. Ticket #1170. (CVS 2408) file: [2134ef43] check-in: [2bf88daa] user: drh branch: trunk, size: 24056
2005-01-15
01:52
Test coverage improvements. (CVS 2215) file: [f3d1f5cd] check-in: [92f9d2b2] user: drh branch: trunk, size: 24036
2004-11-14
21:56
The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) file: [65536e7e] check-in: [98c7a554] user: drh branch: trunk, size: 24071
2004-11-11
01:50
Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) file: [4fd4e90b] check-in: [c85f13f8] user: danielk1977 branch: trunk, size: 24118
2004-11-10
11:55
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) file: [21413a0f] check-in: [8e5c2e5d] user: danielk1977 branch: trunk, size: 24124
2004-11-09
16:13
Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) file: [fcbade13] check-in: [f81b9c1c] user: danielk1977 branch: trunk, size: 24108
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [dbf15c13] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 22634
2004-10-06
15:41
Convert many constants to have type "const". (CVS 2006) file: [34bdb008] check-in: [d790c84c] user: drh branch: trunk, size: 21364
2004-10-01
02:00
Use type i64 instead of off_t for file offsets since off_t is giving portability problems. Ticket #924. (CVS 1992) file: [93927e2d] check-in: [8972c004] user: drh branch: trunk, size: 21358
2004-09-06
17:24
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) file: [eb8d5fa1] check-in: [3ddf5a9d] user: drh branch: trunk, size: 21358
2004-08-17
10:42
Fix a typo in a comment. (CVS 1889) file: [edff4aa8] check-in: [9af1d4d1] user: drh branch: trunk, size: 21357
2004-08-08
20:22
Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) file: [a164e3a5] check-in: [b0659738] user: drh branch: trunk, size: 21357
2004-07-20
00:40
Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1829) file: [54befeaf] check-in: [28c01d2a] user: drh branch: version_2, size: 21216
00:39
Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1828) file: [e1bb384a] check-in: [4e2ad572] user: drh branch: trunk, size: 21320
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: [6ccb9336] check-in: [135e5447] user: drh branch: version_2, size: 21216
22:22
The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1805) file: [d42ea73a] check-in: [50b016b0] user: drh branch: trunk, size: 21320
2004-06-19
08:18
Remove the iCollate argument from sqlite3_create_function() (CVS 1632) file: [b3e8b2be] check-in: [728d57ff] user: danielk1977 branch: trunk, size: 21169
2004-06-12
09:25
(1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [65b483ca] check-in: [5903f538] user: danielk1977 branch: trunk, size: 21172
00:42
Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) file: [2d193dbe] check-in: [9b84f2f4] user: danielk1977 branch: trunk, size: 21102
2004-05-31
18:51
Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) file: [8e6fa317] check-in: [adf7e29f] user: drh branch: trunk, size: 21092
2004-05-26
23:25
Refactoring of the vdbe Mem functions and the APIs that deal with them. The code will not compile in its current state. (CVS 1465) file: [0eb922af] check-in: [bba6684d] user: drh branch: trunk, size: 21094
16:54
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) file: [37bb5784] check-in: [36e03162] user: drh branch: trunk, size: 21094
06:18
Use the new form of the sqlite3_create_function() API. (CVS 1460) file: [1a6a7254] check-in: [0317bef4] user: danielk1977 branch: trunk, size: 21267
2004-05-25
12:05
Change a couple of symbol names for the new user function API. (CVS 1454) file: [098aee0a] check-in: [8f6b20c2] user: danielk1977 branch: trunk, size: 21258
11:47
Use the new API for returning values and errors from user functions. (CVS 1453) file: [b754dc0e] check-in: [4eccae03] user: danielk1977 branch: trunk, size: 21234
2004-05-24
12:39
Non-aggregate SQL functions use sqlite_value* instead of const char * for argument values. (CVS 1449) file: [64fd7169] check-in: [1e47d738] user: danielk1977 branch: trunk, size: 21250
07:04
Have the vdbe handle strings in the same encoding as the database. (CVS 1445) file: [fd6a4649] check-in: [b7155db2] user: danielk1977 branch: trunk, size: 21094
2004-05-14
11:00
Implement type affinity for table and index records (CVS 1375) file: [0eb0a899] check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 21083
2004-05-10
10:34
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1337) file: [1564caa1] check-in: [ba2ba242] user: danielk1977 branch: trunk, size: 21080
2004-05-08
08:23
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) file: [ca325e07] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 21073
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: [f055419d] check-in: [7b3b8968] user: drh branch: trunk, size: 21053
00:50
Try again to get the HH:MM:SS modifier change right... (CVS 1279) file: [33a52678] check-in: [e20d51f9] user: drh branch: trunk, size: 21054
00:48
Fix a bug in the HH:MM:SS modifier change that was just checked in. (CVS 1278) file: [1eaa5014] check-in: [248b5500] user: drh branch: trunk, size: 21014
00:40
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) file: [6cb69543] check-in: [559002a5] user: drh branch: trunk, size: 20964
2004-02-22
17:49
Code cleanup in the date and time functions. (CVS 1263) file: [3025642c] check-in: [9b3bcde1] user: drh branch: trunk, size: 20238
2004-02-21
03:28
Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255) file: [6120c591] check-in: [ffa97193] user: drh branch: trunk, size: 20173
2004-02-10
13:19
Fix for ticket #603. (CVS 1220) file: [c9d2bfd4] check-in: [d0624d25] user: drh branch: trunk, size: 20186
2004-01-17
01:16
Do not use strcpy() on overlapping buffers. (CVS 1187) file: [c6b7e3fa] check-in: [ed6bd2eb] user: drh branch: trunk, size: 20184
2004-01-08
02:17
Remove unused code and tighten existing code to make the library a little smaller. (CVS 1168) file: [bb89fdb9] check-in: [34a6b741] user: drh branch: trunk, size: 20215
2004-01-07
03:29
Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) file: [eef0ccd9] check-in: [70df32b7] user: drh branch: trunk, size: 20561
2003-12-31
17:25
Fix for ticket #542. (CVS 1151) file: [13775c2d] check-in: [458cfa5b] user: drh branch: trunk, size: 20535
2003-12-24
01:41
minor edits for new date.c with mingw/msys on Windows (CVS 1148) file: [d6377867] check-in: [9392c514] user: dougcurrie branch: trunk, size: 20531
2003-12-23
16:34
Update date/time functions so that they correctly handle NULL arguments. (CVS 1147) file: [a69da899] check-in: [a5a5fbd6] user: drh branch: trunk, size: 20524
16:22
Add localtime<-->UTC conversions to the date functions. (CVS 1146) file: [1e3318d8] check-in: [8482b8c4] user: drh branch: trunk, size: 20482
02:17
Use a built-in atof() function instead of the one from the library to avoid problems with locale. Ticket #305. (CVS 1144) file: [ec36ce6f] check-in: [4d9edbc5] user: drh branch: trunk, size: 18681
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: [acb75ff7] check-in: [68ef9b45] user: drh branch: trunk, size: 18675 Added