Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the date and time function documentation to guarantee that 'now' is stable within a single sqlite3_step() call. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
a2842a55e902c16a8784eefecbe3e6e7 |
User & Date: | drh 2013-09-16 13:32:19.325 |
Context
2013-09-18
| ||
11:31 | Add examples of creating fts3tokenize tables that use tokenizers declared with multiple arguments to fts3.in. (check-in: 23c364befb user: dan tags: trunk) | |
2013-09-16
| ||
13:32 | Update the date and time function documentation to guarantee that 'now' is stable within a single sqlite3_step() call. (check-in: a2842a55e9 user: drh tags: trunk) | |
2013-09-14
| ||
16:09 | Merge the 3.8.0 branch changes into trunk. (check-in: 18c0f01b0c user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
23 24 25 26 27 28 29 30 31 32 33 34 35 36 | as hints to the query planner. <li>Added the [soft_heap_limit pragma]. <li>Tweaked the query planner to take into account WHERE clause terms that cannot be used with indices. <li>Added support for SQLITE_ENABLE_STAT4 <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option <li>Added the win32-longpath VFS on windows. } chng {2013-09-03 (3.8.0.2)} { <li>Fix a bug in the optimization that attempts to omit unused LEFT JOINs <li>SQLITE_SOURCE_ID: "2013-09-03 17:11:13 7dd4968f235d6e1ca9547cda9cf3bd570e1609ef" | > > > | 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | as hints to the query planner. <li>Added the [soft_heap_limit pragma]. <li>Tweaked the query planner to take into account WHERE clause terms that cannot be used with indices. <li>Added support for SQLITE_ENABLE_STAT4 <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option <li>Added the win32-longpath VFS on windows. <li>The [Date And Time Functions] are enhanced so that the current time (ex: julianday('now')) is always the same for multiple function invocations within the same [sqlite3_step()] call. } chng {2013-09-03 (3.8.0.2)} { <li>Fix a bug in the optimization that attempts to omit unused LEFT JOINs <li>SQLITE_SOURCE_ID: "2013-09-03 17:11:13 7dd4968f235d6e1ca9547cda9cf3bd570e1609ef" |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 | ^In formats 5 through 7, the "T" is a literal character separating the date and the time, as required by [http://www.w3c.org/TR/NOTE-datetime | ISO-8601]. ^Formats 8 through 10 that specify only a time assume a date of 2000-01-01. Format 11, the string 'now', is converted into the current date and time as obtained from the xCurrentTime method 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> | > > | 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 | ^In formats 5 through 7, the "T" is a literal character separating the date and the time, as required by [http://www.w3c.org/TR/NOTE-datetime | ISO-8601]. ^Formats 8 through 10 that specify only a time assume a date of 2000-01-01. Format 11, the string 'now', is converted into the current date and time as obtained from the xCurrentTime method of the [sqlite3_vfs] object in use. ^The 'now' argument to date and time functions always returns exactly the 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> |
︙ | ︙ |