Conversion Functions

Conversion functions cast values between CamusDB scalar types. NULL input returns NULL.

You can use either explicit conversion functions or SQL CAST syntax:

SELECT to_string(year) AS year_text
FROM robots;

SELECT CAST(year AS string) AS year_text
FROM robots;

Functions

Function	Returns	Description
to_string(value)	STRING	Converts STRING, OID, INT64, FLOAT64, or BOOL to text. Booleans become true or false.
to_int64(value)	INT64	Converts INT64, FLOAT64, BOOL, or integer text. Floats are truncated toward zero. Booleans become 1 or 0.
to_float64(value)	FLOAT64	Converts FLOAT64, INT64, BOOL, or numeric text. Booleans become 1.0 or 0.0.
to_bool(value)	BOOL	Converts BOOL or text equal to true or false, case-insensitively.
to_id(value)	OID	Converts an OID or a 24-character lowercase hex string to an object id.
str_id(value)	OID	Alias for to_id(value).

CAST Targets

CAST(value AS type) accepts the following targets:

Target	Result Type
string	STRING
int64, integer	INT64
float64, double	FLOAT64
bool	BOOL
oid, id, object_id	OID

Examples

SELECT to_int64("42"), to_float64("42.5"), to_bool("TrUe");
-- 42, 42.5, true

SELECT CAST(CAST(7 AS string) AS int64);
-- 7

SELECT name
FROM robots
WHERE CAST(year AS string) = "42";

SELECT id
FROM robots
WHERE id = str_id("507f1f77bcf86cd799439011");

Error Cases

Invalid conversions fail the query. Examples include non-numeric text passed to to_int64 or to_float64, non-boolean text passed to to_bool, non-finite floating-point values, integer overflow, and object id strings that are not 24 lowercase hex characters.