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. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a2842a55e902c16a8784eefecbe3e6e7 |
| User & Date: | drh 2013-09-16 13:32:19 |
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> |