Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Clarify the operation of the "weekday" date and time modifier. |
---|---|
Downloads: | Tarball | ZIP archive |
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.389 |
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 | 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> | | | > > > | 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 |
︙ | ︙ |