CAST operator
Allow converting primitive value from one type to another.
Syntax: CAST(<expr> AS [TEXT | INTEGER | REAL | BLOB | TIMESTAMP])
Example:
SELECT CAST(3.14159265 AS TEXT);
-- 3.14159265
SELECT CAST('3.14159265' AS REAL);
-- 3.1416
SELECT CAST('3.14159265' AS INTEGER);
-- 3
Last Updated: 29 April, 2025
Found something wrong, missing, or unclear on this page? Raise an issue in our repo.