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 3013 so the date is normalized to 2001-05-01. ^A similar effect occurs when 3014 3014 the original date is February 29 of a leapyear and the modifier is 3015 3015 ±N years where N is not a multiple of four.</p> 3016 3016 3017 3017 <p>^The "start of" modifiers (7 through 9) shift the date backwards 3018 3018 to the beginning of the current month, year or day.</p> 3019 3019 3020 -<p>^The "weekday" modifier advances the date forward to the next date 3021 -where the weekday number is N. Sunday is 0, Monday is 1, and so forth.</p> 3020 +<p>^The "weekday" modifier advances the date forward, if necessary, 3021 +to the next date where the weekday number is N. Sunday is 0, Monday is 1, 3022 +and so forth. 3023 +^If the date is already on the desired weekday, the "weekday" modifier 3024 +leaves the date unchanged. </p> 3022 3025 3023 3026 <p>^The "unixepoch" modifier (11) only works if it immediately follows 3024 3027 a timestring in the DDDDDDDDDD format. 3025 3028 ^This modifier causes the DDDDDDDDDD to be interpreted not 3026 3029 as a Julian day number as it normally would be, but as 3027 3030 [http://en.wikipedia.org/wiki/Unix_time | Unix Time] - the 3028 3031 number of seconds since 1970. If the "unixepoch" modifier does not