Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarification of the input time string formats for date/time functions. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
738f9af9caebee1aa41cdbb78ce1fb64 |
| User & Date: | drh 2012-06-27 19:57:29 |
Context
|
2012-07-05
| ||
| 19:35 | Add support for IPv6 to the althttpd.c standalone server. (check-in: 74563a081e user: drh tags: trunk) | |
|
2012-06-27
| ||
| 19:57 | Clarification of the input time string formats for date/time functions. (check-in: 738f9af9ca user: drh tags: trunk) | |
|
2012-06-20
| ||
| 08:42 | Add "Flame" as a notorious user of SQLite. (check-in: 8c4c1ef51e user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 |
of the [sqlite3_vfs] object in use. ^[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> <h3>Modifiers</h3> <p>^The time string can be followed by zero or more modifiers that alter date and/or time. ^Each modifier is a transformation that is applied to the time value to its left. ^Modifiers are applied from left to right; order is important. ^(The available modifiers are as follows.</p> |
> > > > > > > > > > > |
2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 |
of the [sqlite3_vfs] object in use. ^[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 functions will really accept as many or as few digits as are necessary to represent the Julian day number. </p> <h3>Modifiers</h3> <p>^The time string can be followed by zero or more modifiers that alter date and/or time. ^Each modifier is a transformation that is applied to the time value to its left. ^Modifiers are applied from left to right; order is important. ^(The available modifiers are as follows.</p> |