Documentation Source Text

Check-in [b4b8f35ef1]
Login

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: b4b8f35ef1522400530e555bb6c939d78ad47d23758c1426f859d6b3a04e6fa6
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
Side-by-Side Diff Show Whitespace Changes Patch
Changes to pages/lang.in.
3013
3014
3015
3016
3017
3018
3019
3020
3021





3022
3023
3024
3025
3026
3027
3028
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
&plusmn;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 "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