Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation on the optional timezone suffixes to timestrings in the date and time functions. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d4924d1139c6c1f9ca963fa2fb5fef04 |
| User & Date: | drh 2013-10-07 08:27:34 |
Context
|
2013-10-08
| ||
| 15:07 | Revise the description of the Tcler's wiki database corruption event. check-in: 63ad7e56b1 user: drh tags: trunk | |
|
2013-10-07
| ||
| 08:27 | Add documentation on the optional timezone suffixes to timestrings in the date and time functions. check-in: d4924d1139 user: drh tags: trunk | |
|
2013-10-04
| ||
| 17:27 | Add new bullets to the change log for 3.8.1. check-in: dc132e270c user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 |
same value for multiple invocations within the same [sqlite3_step()] call. ^[http://en.wikipedia.org/wiki/Coordinated_Universal_Time | Universal Coordinated Time (UTC)] is used. ^Format 12 is the [http://en.wikipedia.org/wiki/Julian_day | Julian day number] expressed as a floating point value. </p> <p> ^(In formats 4, 7, and 10, the fractional seconds value SS.SSS can have one or more digits following the decimal point. Exactly three digits are shown in the examples because only the first three digits are significant to the result, but the input string can have fewer or more than three digits and the date/time functions will still operate correctly.)^ Similarly, format 12 is shown with 10 significant digits, but the date/time |
> > > > > > > > > > > > > > > |
2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 |
same value for multiple invocations within the same [sqlite3_step()] call. ^[http://en.wikipedia.org/wiki/Coordinated_Universal_Time | Universal Coordinated Time (UTC)] is used. ^Format 12 is the [http://en.wikipedia.org/wiki/Julian_day | Julian day number] expressed as a floating point value. </p> <p> Formats 2 through 10 may be optionally followed by a timezone indicator of the form "<i>[+-]HH:MM</i>" or just "<i>Z</i>". The date and time functions use UTC or "zulu" time internally, and so the "Z" suffix is a no-op. Any non-zero "HH:MM" suffix is subtracted from the indicated date and time in order to compute zulu time. For example, all of the following time strings are equivalent: </p> <blockquote> 2013-10-07 08:23:19.120<br> 2013-10-07T08:23:19.120Z<br> 2013-10-07 08:23:19.120-04:00<br> 2456572.84952685 </blockquote> <p> ^(In formats 4, 7, and 10, the fractional seconds value SS.SSS can have one or more digits following the decimal point. Exactly three digits are shown in the examples because only the first three digits are significant to the result, but the input string can have fewer or more than three digits and the date/time functions will still operate correctly.)^ Similarly, format 12 is shown with 10 significant digits, but the date/time |