Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the "quirks.html" document. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
7dce3c2f8ae46bd0f3ba47c7d3f029e0 |
| User & Date: | drh 2019-10-18 02:16:29 |
Context
|
2019-10-21
| ||
| 14:57 | Update the CREATE TRIGGER documentation to acknowledge the fact that columns in the UPDATE OF syntax of CREATE TRIGGER need not exist in the table, and that the trigger only fires if one of the columns named in the UPDATE OF clause appear on the left-hand side of one of the terms in the SET clause of the UPDATE statement. check-in: 998c5310eb user: drh tags: trunk | |
|
2019-10-18
| ||
| 02:16 | Fix a typo in the "quirks.html" document. check-in: 7dce3c2f8a user: drh tags: trunk | |
|
2019-10-16
| ||
| 18:07 | Fix typos in the lemon documentation. check-in: 85bc3983a5 user: drh tags: trunk | |
Changes
Changes to pages/quirks.in.
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 |
<h2>No Separate DATETIME Datatype</h2>
<p>
SQLite has no DATETIME datatype.
Instead, dates and times can be stored in any of these ways:
<ul>
<li> As a TEXT string in the ISO-8610 format. Example: '2018-04-02 12:13:46'.
<li> As an INTEGER number of seconds since 1970 (also known as "unix time").
<li> As a REAL value that is the fractional
[https://en.wikipedia.org/wiki/Julian_day|Julian day number].
</ul>
<p>
The built-in [date and time functions] of SQLite understand date/times in
|
| |
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 |
<h2>No Separate DATETIME Datatype</h2>
<p>
SQLite has no DATETIME datatype.
Instead, dates and times can be stored in any of these ways:
<ul>
<li> As a TEXT string in the ISO-8601 format. Example: '2018-04-02 12:13:46'.
<li> As an INTEGER number of seconds since 1970 (also known as "unix time").
<li> As a REAL value that is the fractional
[https://en.wikipedia.org/wiki/Julian_day|Julian day number].
</ul>
<p>
The built-in [date and time functions] of SQLite understand date/times in
|