Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Date And Time Functions
(lang_datefunc.html)
... Examples
Compute the current date.
SELECT date();
Compute the last day of the current month.
SELECT date('now','start of month','+1 month','-1 day');
Compute the date and time given a unix timestamp 1092941466.
SELECT datetime(1092941466, 'unixepoch');
SELECT ...
|
|
Deterministic SQL Functions
(deterministic.html)
3. Special-case Processing For Date/Time Functions
The built-in date and time functions of SQLite are a special case.
These functions are usually considered deterministic. However, if
these functions use the string "now" as the date, or if they use
the localtime modifier or the utc ...
|
|
SQLite Copyright Release Template
(copyright-release.html)
... I dedicate to the public domain
any and all copyright interest in the SQLite software that
was publicly available on the SQLite website (http://www.sqlite.org/) prior
to the date of the signature below and any changes or enhancements ...
|
|
How To Download Canonical SQLite Source Code
(getthecode.html)
3. Obtaining Code Directly From the Version Control System
... If
you know the approximate date of the version you want to download, you
can add a query parameter like "c=YYYY-MM-DD" to the "timeline" URL to
see a timeline centered on that date. For example, to see ...
|
|
Row Values
(rowvalue.html)
3.2. Comparison of dates stored as separate fields
The usual way of storing a date in a database table is as a single
field, as either a unix timestamp, a julian day number, or an ISO-8601
dates string. But some application store dates as three separate
fields ...
|
|
Query Language Understood by SQLite
(lang.html)
... aggregate functions
ALTER TABLE
ANALYZE
ATTACH DATABASE
BEGIN TRANSACTION
comment
COMMIT TRANSACTION
core functions
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
date and time functions
DELETE
DETACH DATABASE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW ...
|
|
C API: Compile-Time Library Version Numbers
(c3ref/c_source_id.html)
SQLITE_VERSION, SQLITE_VERSION_NUMBER, SQLITE_SOURCE_ID
... The SQLITE_SOURCE_ID
string contains the date and time of the check-in (UTC) and a SHA1
or SHA3-256 hash of the entire source tree. If the source code has
been edited in any way since it was last checked ...
|
|
SQLite Download Page
(download.html)
... sqlite-product-version.zip
sqlite-product-version.tar.gz
sqlite-product-os-cpu-version.zip
sqlite-product-date.zip
Templates (1) and (2) are used for source-code products. Template (1) is
used for generic source-code products and templates ...
|
|
Datatypes In SQLite
(datatype3.html)
2.2. Date and Time Datatype
SQLite does not have a storage class set aside for storing
dates and/or times.
Instead, the built-in Date And Time Functions of SQLite are capable of
storing dates and times as TEXT, REAL, or INTEGER values:
TEXT as ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... The xCurrentTime()
method returns a Julian Day Number for the current date and time as
a floating point value.
The xCurrentTimeInt64() method returns, as an integer, the Julian
Day Number multiplied by 86400000 (the number of milliseconds in
a 24 ...
|
Page generated by FTS5 in about 38.07 ms.