Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQL Language Expressions
(lang_expr.html)
... CAST expressions
A CAST expression of the form "CAST(expr AS type-name)"
is used to convert the value of expr to
a different storage class specified by type-name.
A CAST conversion is similar to the conversion that takes ...
|
|
C API: File Name
(c3ref/filename.html)
... It may be cast to (const char*) and treated
as a normal, nul-terminated, UTF-8 buffer containing the filename, but
may also be passed to special APIs such as:
sqlite3_filename_database()
sqlite3_filename_journal()
sqlite3_filename_wal()
sqlite3_uri_parameter()
sqlite3_uri_boolean()
sqlite3_uri_int64()
sqlite3_uri_key()
See also lists ...
|
|
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings
If you CAST a string into a BLOB, then the entire length of the
string is shown. For example:
SELECT a, CAST(b AS BLOB) FROM t1;
Gives this result:
1,X'6162630078797a'
In the BLOB output, you can clearly ...
|
|
DELETE
(lang_delete.html)
... If a DELETE statement has a LIMIT clause, the maximum number of rows that
will be deleted is found by evaluating the accompanying expression and casting
it to an integer value. If the result of the evaluating the LIMIT clause ...
|
|
Datatypes In SQLite
(datatype3.html)
5. Operators
... The implied type conversion of mathematical operands is slightly different
from CAST to NUMERIC in that string and BLOB values that
look like real numbers but have no fractional part are kept as REAL
instead of being converted into INTEGER ...
|
|
UPDATE
(lang_update.html)
... If an UPDATE statement has a LIMIT clause, the maximum number of rows that
will be updated is found by evaluating the accompanying expression and casting
it to an integer value. A negative value is interpreted as "no limit".
If ...
|
|
SQLite Keywords
(lang_keywords.html)
... ABORT
ACTION
ADD
AFTER
ALL
ALTER
ALWAYS
ANALYZE
AND
AS
ASC
ATTACH
AUTOINCREMENT
BEFORE
BEGIN
BETWEEN
BY
CASCADE
CASE
CAST
CHECK
COLLATE
COLUMN
COMMIT
CONFLICT
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DETACH
DISTINCT ...
|
|
SQLite Older News
(oldnews.html)
... In
all prior versions of SQLite, a cast from a very large positive
floating point number into an integer resulted in the most negative integer.
In other words, CAST(+99.9e99 to INT) would yield -9223372036854775808.
This behavior came about ...
|
|
CREATE TABLE
(lang_createtable.html)
... Each
time a new row is inserted into the table or an existing row is updated,
the expression associated with each CHECK constraint is evaluated and
cast to a NUMERIC value in the same way as a CAST expression. If ...
|
|
Date And Time Functions
(lang_datefunc.html)
... FunctionEquivalent strftime()
date(...) strftime('%F', ...)
time(...) strftime('%T', ...)
datetime(...) strftime('%F %T', ...)
julianday(...) CAST(strftime('%J', ...) as REAL)
unixepoch(...) CAST(strftime('%s', ...) as INT)
The date(), time(), and datetime() functions all return text, and so their
strftime() equivalents are exact ...
|
Page generated by FTS5 in about 37.97 ms.