Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarify the operation of the "weekday" date and time modifier. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.25 |
| Files: | files | file ages | folders |
| SHA3-256: |
b4b8f35ef1522400530e555bb6c939d7 |
| User & Date: | drh 2018-09-24 14:46:58 |
Context
|
2018-09-25
| ||
| 15:02 | Preliminary changes for version 3.25.2. check-in: e00e728eae user: drh tags: branch-3.25 | |
|
2018-09-24
| ||
| 14:46 | Clarify the operation of the "weekday" date and time modifier. check-in: b4b8f35ef1 user: drh tags: branch-3.25 | |
| 14:38 | Improved linkage to window functions. check-in: 1c7ab913f0 user: drh tags: branch-3.25 | |
Changes
Changes to pages/lang.in.
3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 |
so the date is normalized to 2001-05-01. ^A similar effect occurs when the original date is February 29 of a leapyear and the modifier is ±N years where N is not a multiple of four.</p> <p>^The "start of" modifiers (7 through 9) shift the date backwards to the beginning of the current month, year or day.</p> <p>^The "weekday" modifier advances the date forward to the next date where the weekday number is N. Sunday is 0, Monday is 1, and so forth.</p> <p>^The "unixepoch" modifier (11) only works if it immediately follows a timestring in the DDDDDDDDDD format. ^This modifier causes the DDDDDDDDDD to be interpreted not as a Julian day number as it normally would be, but as [http://en.wikipedia.org/wiki/Unix_time | Unix Time] - the number of seconds since 1970. If the "unixepoch" modifier does not |
| | > > > |
3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 |
so the date is normalized to 2001-05-01. ^A similar effect occurs when the original date is February 29 of a leapyear and the modifier is ±N years where N is not a multiple of four.</p> <p>^The "start of" modifiers (7 through 9) shift the date backwards to the beginning of the current month, year or day.</p> <p>^The "weekday" modifier advances the date forward, if necessary, to the next date where the weekday number is N. Sunday is 0, Monday is 1, and so forth. ^If the date is already on the desired weekday, the "weekday" modifier leaves the date unchanged. </p> <p>^The "unixepoch" modifier (11) only works if it immediately follows a timestring in the DDDDDDDDDD format. ^This modifier causes the DDDDDDDDDD to be interpreted not as a Julian day number as it normally would be, but as [http://en.wikipedia.org/wiki/Unix_time | Unix Time] - the number of seconds since 1970. If the "unixepoch" modifier does not |