Documentation Source Text

All files named "pages/lang_datefunc.in"
Login

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

History for pages/lang_datefunc.in

2024-08-13
13:30
[ab33c4f78f] part of check-in [32c3448fe5] Typo fix in date-time functions. (check-in: [32c3448fe5] user: drh branch: branch-3.46, size: 22485)
2024-04-16
16:29
[91b979fe1e] part of check-in [4159d99277] Fix a few misspellings and grammos. (check-in: [4159d99277] user: larrybr branch: trunk, size: 22485)
2024-03-29
20:49
[2f05e2885e] part of check-in [2b52ce704e] More tweaks to the date/time function documentation. (check-in: [2b52ce704e] user: drh branch: trunk, size: 22483)
17:56
[bb7da58a0e] part of check-in [b665a4c6ef] Improved formatting (less whitespace) in the time-value format table. (check-in: [b665a4c6ef] user: drh branch: trunk, size: 22466)
17:49
[eab1c3a170] part of check-in [5a2217dc58] Attempted improvement to the date/time function documentation. (check-in: [5a2217dc58] user: drh branch: trunk, size: 22555)
2024-03-14
11:05
[5abae4b091] part of check-in [07fa5fc08f] Clarify documentation of date/time functions. (check-in: [07fa5fc08f] user: drh branch: trunk, size: 21657)
2024-03-04
14:26
[7130caf560] part of check-in [755f0ef018] Updates to date/time documentation to cover the new ceiling and floor modifiers. (check-in: [755f0ef018] user: drh branch: trunk, size: 21554)
2024-03-02
20:58
[bbb6f470f6] part of check-in [a69e7c0dfe] Document the (no yet landed) "mnth" and "yr" date interval modifiers. (check-in: [a69e7c0dfe] user: drh branch: trunk, size: 22315)
2024-01-29
04:50
[eb291a29ad] part of check-in [822b36a31a] SQL result typo fix reported in the forum and confirmed in /fiddle. (check-in: [822b36a31a] user: stephan branch: branch-3.45, size: 21055)
04:49
[1234674e19] part of check-in [5acd77fc59] SQL result typo fix reported in the forum and confirmed in /fiddle. (check-in: [5acd77fc59] user: stephan branch: trunk, size: 21483)
2024-01-19
01:09
[e16cd91d5e] part of check-in [f184d6507b] Start recording changes for 3.46.0. Add documentation for the enhancements to strftime(). (check-in: [f184d6507b] user: drh branch: trunk, size: 21483)
2023-10-26
01:12
[5409636a72] part of check-in [e1bb367b33] Fix typo in the strftime() documentation. Forum post dcbb75d3e3. (check-in: [e1bb367b33] user: drh branch: trunk, size: 21055)
2023-10-24
19:38
[4651b6186d] part of check-in [21f2c6d95f] Additional detail and cross-linking of SQL function documentation. (check-in: [21f2c6d95f] user: drh branch: trunk, size: 21055)
2023-09-08
12:42
[13eade8808] part of check-in [b827623d78] Fix grammo reported in forum. (check-in: [b827623d78] user: drh branch: branch-3.43, size: 20545)
2023-09-07
20:42
[6a42b1de55] part of check-in [bb23eb2b79] Fix grammo reported in forum. (check-in: [bb23eb2b79] user: larrybr branch: trunk, size: 21037)
2023-08-29
19:12
[0f1cf2c0f1] part of check-in [ffcfef0089] Document the new conversion letters for strftime(). (check-in: [ffcfef0089] user: drh branch: trunk, size: 21040)
2023-08-01
13:58
[68db3dc2dd] part of check-in [de7ff77b42] Enhancements to the date/time documentation and expecially regarding the new timediff() function. (check-in: [de7ff77b42] user: drh branch: trunk, size: 20548)
2023-06-19
17:16
[0b711a6cf5] part of check-in [9ed168eaff] Minor enhancement to the date/time examples. (check-in: [9ed168eaff] user: drh branch: trunk, size: 19294)
2023-05-30
12:46
[780c5ab9a5] part of check-in [71097e7496] Preliminary documentation for the new timediff() function. (check-in: [71097e7496] user: drh branch: timediff, size: 19143)
2023-05-04
20:20
[76613d01dc] part of check-in [16861f41cb] Add documentation about the subsecond modifier to date/time functions in anticipation of merging that enhancement to trunk. (check-in: [16861f41cb] user: drh branch: trunk, size: 16931)
2023-03-30
18:34
[39edc16f5e] part of check-in [30020367e9] Say how unixepoch() deals with fractional seconds on input. (check-in: [30020367e9] user: larrybr branch: trunk, size: 15310)
2023-02-22
21:47
[d9ffff24d8] part of check-in [4e18c20631] Alleviate a distracting awkwardness in explication. (check-in: [4e18c20631] user: larrybr branch: trunk, size: 15320)
2023-02-08
12:39
[20dfcc714b] part of check-in [bddfe9ebb1] Update documentation of date/time functions to talk about the new 'txn' format. (check-in: [bddfe9ebb1] user: drh branch: trunk, size: 16064)
2022-01-27
15:08
[5e55e49a95] part of check-in [7f809741df] Fix typo in the date/time function documentation: "data" should be "date". (check-in: [7f809741df] user: drh branch: trunk, size: 15314)
13:52
[c9d13d2d91] part of check-in [eaccf62910] Update requirements marks for date-time functions. (check-in: [eaccf62910] user: drh branch: trunk, size: 15314)
12:42
[90f8dd2c1f] part of check-in [0dbb181411] Updates to requirements marks and wording of the date/time functions. (check-in: [0dbb181411] user: drh branch: trunk, size: 15313)
00:19
[8ffe599cd6] part of check-in [5fca4e2367] Note inexactitude of strftime() %J and %s format specifiers (check-in: [5fca4e2367] user: larrybr branch: trunk, size: 15002)
2022-01-26
15:41
[9ccfa556a5] part of check-in [841107fc38] Clarify that "Julian day number" need not be a "whole number" (check-in: [841107fc38] user: larrybr branch: trunk, size: 14712)
2022-01-21
19:26
[360991fe0d] part of check-in [deb6d14033] Add requirements marks to newer parts of the date/time documentation. (check-in: [deb6d14033] user: drh branch: trunk, size: 14688)
2022-01-12
18:53
[00508b833b] part of check-in [fa3813c824] Fix typos in datefunc doc and clarify slightly (check-in: [fa3813c824] user: larrybr branch: trunk, size: 14668)
2021-12-20
15:06
[c2d8f47584] part of check-in [9cfef57af3] Update the change log for 3.38.0. (check-in: [9cfef57af3] user: drh branch: trunk, size: 14608)
2021-12-12
22:55
[84dbc716b8] part of check-in [99e87aed86] fix 1-char typo per https://sqlite.org/forum/forumpost/dbd15b2206 (check-in: [99e87aed86] user: larrybr branch: trunk, size: 14395)
2021-11-29
18:52
[6f1284ce96] part of check-in [7b3c3b904e] First cut at improving the date/time function documentation to incorporate the new unixepoch() function and new modifiers. (check-in: [7b3c3b904e] user: drh branch: trunk, size: 14395)
2020-12-13
19:57
[4d5f8768b1] part of check-in [733790e205] Update the date/time function documentation to avoid the use of the term "time string", which is confusing to some readers. (check-in: [733790e205] user: drh branch: branch-3.34, size: 11457)
2020-02-10
20:33
Added: [6046cb6fed] part of check-in [ca272c33f2] Finish splitting the lang.in source file into separate parts. (check-in: [ca272c33f2] user: drh branch: trunk, size: 11338)