FunctionsType Conversion
Type Conversion
203 Type Conversion functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.
203 functions in the type_conversion family. Each name links to its page; … marks the variadic argument list (the engine declares no named parameters). A Measured value appears only where a benchmark corpus case joins by name (server-class hardware, median).
| Function | Type | Description | Measured |
|---|---|---|---|
cast(…) → Dynamic | scalar | Convert a value to a target type. | — |
cast_as_ascii(…) → String | scalar | Cast to ASCII. | — |
cast_as_bigint(…) → Int64 | scalar | Cast to bigint. | — |
cast_as_blob(…) → Bytes | scalar | Cast to BLOB. | — |
cast_as_boolean(…) → Bool | scalar | Cast to Boolean. | — |
cast_as_counter(…) → UInt64 | scalar | Cast to Counter. | — |
cast_as_date(…) → Date | scalar | Cast to Date. | — |
cast_as_decimal(…) → Float64 | scalar | Cast to Decimal. | — |
cast_as_double(…) → Float64 | scalar | Cast to Float64. | — |
cast_as_duration(…) → Int64 | scalar | Cast to Duration. | — |
cast_as_empty(…) → String | scalar | Cast to empty. | — |
cast_as_float(…) → Float64 | scalar | Cast to Float64. | — |
cast_as_inet(…) → String | scalar | Cast to INET. | — |
cast_as_int(…) → Int64 | scalar | Cast to int. | — |
cast_as_smallint(…) → Int64 | scalar | Cast to smallint. | — |
cast_as_text(…) → String | scalar | Cast to Text. | — |
cast_as_time(…) → String | scalar | Cast to Time. | — |
cast_as_timestamp(…) → Timestamp | scalar | Cast to Timestamp. | — |
cast_as_timeuuid(…) → UUID | scalar | Cast to TimeUUID. | — |
cast_as_tinyint(…) → Int8 | scalar | Cast to tinyint. | — |
cast_as_uuid(…) → UUID | scalar | Cast to UUID. | — |
cast_as_varint(…) → String | scalar | Cast to Varint. | — |
castas(…) → Dynamic | scalar | Cast using a runtime-specified target type. | — |
coalesce(…) → Dynamic | scalar | First non-NULL value. | — |
if(…) → Dynamic | scalar | Conditional expression. | — |
if_null(…) → Dynamic | scalar | Return a fallback when NULL. | — |
is_not_null(…) → Bool | scalar | Non-NULL test. | — |
is_null(…) → Bool | scalar | NULL test. | — |
multi_if(…) → Dynamic | scalar | Multi-branch conditional expression. | — |
null_if(…) → Dynamic | scalar | Map a specific value to NULL. | — |
reinterpret_as_date(…) → Date | scalar | Reinterpret bytes as Date. | — |
reinterpret_as_date_time(…) → DateTime | scalar | Reinterpret bytes as DateTime. | — |
reinterpret_as_datetime(…) → DateTime | scalar | Reinterpret bytes as DateTime. | — |
reinterpret_as_fixed_string(…) → FixedString | scalar | Reinterpret bytes as FixedString. | — |
reinterpret_as_float32(…) → Float32 | scalar | Reinterpret bytes as Float32. | — |
reinterpret_as_float64(…) → Float64 | scalar | Reinterpret bytes as Float64. | — |
reinterpret_as_int128(…) → Int128 | scalar | Reinterpret bytes as Int128. | — |
reinterpret_as_int16(…) → Int16 | scalar | Reinterpret bytes as Int16. | — |
reinterpret_as_int256(…) → Int256 | scalar | Reinterpret bytes as Int256. | — |
reinterpret_as_int32(…) → Int32 | scalar | Reinterpret bytes as Int32. | — |
reinterpret_as_int64(…) → Int64 | scalar | Reinterpret bytes as Int64. | — |
reinterpret_as_int8(…) → Int8 | scalar | Reinterpret bytes as Int8. | — |
reinterpret_as_string(…) → String | scalar | Reinterpret bytes as String. | — |
reinterpret_as_uint128(…) → UInt128 | scalar | Reinterpret bytes as UInt128. | — |
reinterpret_as_uint16(…) → UInt16 | scalar | Reinterpret bytes as UInt16. | — |
reinterpret_as_uint256(…) → UInt256 | scalar | Reinterpret bytes as UInt256. | — |
reinterpret_as_uint32(…) → UInt32 | scalar | Reinterpret bytes as UInt32. | — |
reinterpret_as_uint64(…) → UInt64 | scalar | Reinterpret bytes as UInt64. | — |
reinterpret_as_uint8(…) → UInt8 | scalar | Reinterpret bytes as UInt8. | — |
reinterpret_as_uuid(…) → UUID | scalar | Reinterpret bytes as UUID. | — |
to_ascii(…) → String | scalar | Convert to ASCII. | — |
to_base64(…) → String | scalar | Encode as Base64. | — |
to_bin(…) → String | scalar | Format a number as binary. | — |
to_bool(…) → Bool | scalar | Convert to Boolean. | — |
to_bool_or_default(…) → Bool | scalar | Convert to Boolean (fallback default). | — |
to_char(…) → String | scalar | Convert to a single character. | — |
to_column_type_name(…) → String | scalar | Return a column type name. | — |
to_date_or_default(…) → Date | scalar | Convert to Date (fallback default). | — |
to_date_or_null(…) → Date | scalar | Convert to Date (fallback null). | — |
to_date_or_zero(…) → Date | scalar | Convert to Date (fallback zero). | — |
to_date_time_or_default(…) → DateTime | scalar | Convert to DateTime (fallback default). | — |
to_date_time64_or_default(…) → DateTime64 | scalar | Convert to DateTime64 (fallback default). | — |
to_date16(…) → Date | scalar | Convert to Date16. | — |
to_date32_or_default(…) → Date32 | scalar | Convert to Date32 (fallback default). | — |
to_date32_or_null(…) → Date32 | scalar | Convert to Date32 (fallback null). | — |
to_date32_or_zero(…) → Date32 | scalar | Convert to Date32 (fallback zero). | — |
to_datetime_or_default(…) → DateTime | scalar | Convert to DateTime (fallback default). | — |
to_datetime_or_null(…) → DateTime | scalar | Convert to DateTime (fallback null). | — |
to_datetime_or_zero(…) → DateTime | scalar | Convert to DateTime (fallback zero). | — |
to_datetime32(…) → DateTime | scalar | Convert to DateTime32. | — |
to_datetime64_or_default(…) → DateTime64 | scalar | Convert to DateTime64 (fallback default). | — |
to_datetime64_or_null(…) → DateTime64 | scalar | Convert to DateTime64 (fallback null). | — |
to_datetime64_or_zero(…) → DateTime64 | scalar | Convert to DateTime64 (fallback zero). | — |
to_days(…) → Int64 | scalar | Convert to a day number. | — |
to_decimal(…) → Decimal64 | scalar | Convert to Decimal. | — |
to_decimal_string(…) → String | scalar | Convert a decimal to a canonical string. | — |
to_decimal128(…) → Decimal128 | scalar | Convert to Decimal128. | — |
to_decimal128_or_default(…) → Decimal128 | scalar | Convert to Decimal128 (fallback default). | — |
to_decimal128_or_null(…) → Decimal128 | scalar | Convert to Decimal128 (fallback null). | — |
to_decimal128_or_zero(…) → Decimal128 | scalar | Convert to Decimal128 (fallback zero). | — |
to_decimal256(…) → Decimal256 | scalar | Convert to Decimal256. | — |
to_decimal256_or_default(…) → Decimal256 | scalar | Convert to Decimal256 (fallback default). | — |
to_decimal256_or_null(…) → Decimal256 | scalar | Convert to Decimal256 (fallback null). | — |
to_decimal256_or_zero(…) → Decimal256 | scalar | Convert to Decimal256 (fallback zero). | — |
to_decimal32(…) → Decimal32 | scalar | Convert to Decimal32. | — |
to_decimal32_or_default(…) → Decimal32 | scalar | Convert to Decimal32 (fallback default). | — |
to_decimal32_or_null(…) → Decimal32 | scalar | Convert to Decimal32 (fallback null). | — |
to_decimal32_or_zero(…) → Decimal32 | scalar | Convert to Decimal32 (fallback zero). | — |
to_decimal64(…) → Decimal64 | scalar | Convert to Decimal64. | — |
to_decimal64_or_default(…) → Decimal64 | scalar | Convert to Decimal64 (fallback default). | — |
to_decimal64_or_null(…) → Decimal64 | scalar | Convert to Decimal64 (fallback null). | — |
to_decimal64_or_zero(…) → Decimal64 | scalar | Convert to Decimal64 (fallback zero). | — |
to_fixed_string(…) → FixedString | scalar | Convert to FixedString. | — |
to_float(…) → Float64 | scalar | Convert to Float64. | — |
to_float32(…) → Float32 | scalar | Convert to Float32. | — |
to_float32_or_default(…) → Float32 | scalar | Convert to Float32 (fallback default). | — |
to_float32_or_null(…) → Float32 | scalar | Convert to Float32 (fallback null). | — |
to_float32_or_zero(…) → Float32 | scalar | Convert to Float32 (fallback zero). | — |
to_float64(…) → Float64 | scalar | Convert to Float64. | — |
to_float64_or_default(…) → Float64 | scalar | Convert to Float64 (fallback default). | — |
to_float64_or_null(…) → Float64 | scalar | Convert to Float64 (fallback null). | — |
to_float64_or_zero(…) → Float64 | scalar | Convert to Float64 (fallback zero). | — |
to_hex(…) → String | scalar | Format a number as hexadecimal. | — |
to_i_pv4_or_default(…) → IPv4 | scalar | Convert to IPv4 (fallback default). | — |
to_i_pv6_or_default(…) → IPv6 | scalar | Convert to IPv6 (fallback default). | — |
to_int(…) → Int64 | scalar | Convert to int. | — |
to_int128(…) → Int128 | scalar | Convert to Int128. | — |
to_int128_or_default(…) → Int128 | scalar | Convert to Int128 (fallback default). | — |
to_int128_or_null(…) → Int128 | scalar | Convert to Int128 (fallback null). | — |
to_int128_or_zero(…) → Int128 | scalar | Convert to Int128 (fallback zero). | — |
to_int16(…) → Int16 | scalar | Convert to Int16. | — |
to_int16_or_default(…) → Int16 | scalar | Convert to Int16 (fallback default). | — |
to_int16_or_null(…) → Int16 | scalar | Convert to Int16 (fallback null). | — |
to_int16_or_zero(…) → Int16 | scalar | Convert to Int16 (fallback zero). | — |
to_int256(…) → Int256 | scalar | Convert to Int256. | — |
to_int256_or_default(…) → Int256 | scalar | Convert to Int256 (fallback default). | — |
to_int256_or_null(…) → Int256 | scalar | Convert to Int256 (fallback null). | — |
to_int256_or_zero(…) → Int256 | scalar | Convert to Int256 (fallback zero). | — |
to_int32(…) → Int32 | scalar | Convert to Int32. | — |
to_int32_or_default(…) → Int32 | scalar | Convert to Int32 (fallback default). | — |
to_int32_or_null(…) → Int32 | scalar | Convert to Int32 (fallback null). | — |
to_int32_or_zero(…) → Int32 | scalar | Convert to Int32 (fallback zero). | — |
to_int64(…) → Int64 | scalar | Convert to Int64. | — |
to_int64_or_default(…) → Int64 | scalar | Convert to Int64 (fallback default). | — |
to_int64_or_null(…) → Int64 | scalar | Convert to Int64 (fallback null). | — |
to_int64_or_zero(…) → Int64 | scalar | Convert to Int64 (fallback zero). | — |
to_int8(…) → Int8 | scalar | Convert to Int8. | — |
to_int8_or_default(…) → Int8 | scalar | Convert to Int8 (fallback default). | — |
to_int8_or_null(…) → Int8 | scalar | Convert to Int8 (fallback null). | — |
to_int8_or_zero(…) → Int8 | scalar | Convert to Int8 (fallback zero). | — |
to_interval(…) → Int64 | scalar | Create an interval. | — |
to_interval_day(…) → Int64 | scalar | Create an interval (day). | — |
to_interval_hour(…) → Int64 | scalar | Create an interval (hour). | — |
to_interval_microsecond(…) → Int64 | scalar | Create an interval (microsecond). | — |
to_interval_millisecond(…) → Int64 | scalar | Create an interval (millisecond). | — |
to_interval_minute(…) → Int64 | scalar | Create an interval (minute). | — |
to_interval_month(…) → Int64 | scalar | Create an interval (month). | — |
to_interval_nanosecond(…) → Int64 | scalar | Create an interval (nanosecond). | — |
to_interval_quarter(…) → Int64 | scalar | Create an interval (quarter). | — |
to_interval_second(…) → Int64 | scalar | Create an interval (second). | — |
to_interval_week(…) → Int64 | scalar | Create an interval (week). | — |
to_interval_year(…) → Int64 | scalar | Create an interval (year). | — |
to_ipv4(…) → IPv4 | scalar | Convert to IPv4. | — |
to_ipv4_or_default(…) → IPv4 | scalar | Convert to IPv4 (fallback default). | — |
to_ipv4_or_null(…) → IPv4 | scalar | Convert to IPv4 (fallback null). | — |
to_ipv4_or_zero(…) → IPv4 | scalar | Convert to IPv4 (fallback zero). | — |
to_ipv6(…) → IPv6 | scalar | Convert to IPv6. | — |
to_ipv6_or_default(…) → IPv6 | scalar | Convert to IPv6 (fallback default). | — |
to_ipv6_or_null(…) → IPv6 | scalar | Convert to IPv6 (fallback null). | — |
to_ipv6_or_zero(…) → IPv6 | scalar | Convert to IPv6 (fallback zero). | — |
to_last_day_of_month(…) → Date | scalar | Last day of month. | — |
to_low_cardinality(…) → String | scalar | Convert to LowCardinality wrapper. | — |
to_modified_julian_day(…) → Int64 | scalar | Convert to Modified Julian Day. | — |
to_modified_julian_day_or_null(…) → Int64 | scalar | Convert to Modified Julian Day. | — |
to_monday(…) → Date | scalar | Truncate date to the start of the week (Monday). | — |
to_nullable(…) → String | scalar | Convert to Nullable wrapper. | — |
to_number(…) → Float64 | scalar | Parse a number. | — |
to_oct(…) → String | scalar | Format a number as octal. | — |
to_regclass(…) → UInt64 | scalar | Convert to RegClass. | — |
to_regcollation(…) → UInt64 | scalar | Convert to RegCollation. | — |
to_regdatabase(…) → UInt64 | scalar | Convert to RegDatabase. | — |
to_regnamespace(…) → UInt64 | scalar | Convert to RegNamespace. | — |
to_regoper(…) → UInt64 | scalar | Convert to RegOper. | — |
to_regoperator(…) → UInt64 | scalar | Convert to RegOperator. | — |
to_regproc(…) → UInt64 | scalar | Convert to RegProc. | — |
to_regprocedure(…) → UInt64 | scalar | Convert to RegProcedure. | — |
to_regrole(…) → UInt64 | scalar | Convert to RegRole. | — |
to_regtype(…) → UInt64 | scalar | Convert to RegType. | — |
to_regtypemod(…) → UInt64 | scalar | Convert to RegTypeMod. | — |
to_string(…) → String | scalar | Convert to String. | — |
to_string_cut_to_zero(…) → String | scalar | Convert to string_cut_to_zero. | — |
to_tsquery(…) → String | scalar | Convert to TSQuery. | — |
to_type_name(…) → String | scalar | Return a type name. | — |
to_uint128(…) → UInt128 | scalar | Convert to UInt128. | — |
to_uint128_or_default(…) → UInt128 | scalar | Convert to UInt128 (fallback default). | — |
to_uint128_or_null(…) → UInt128 | scalar | Convert to UInt128 (fallback null). | — |
to_uint128_or_zero(…) → UInt128 | scalar | Convert to UInt128 (fallback zero). | — |
to_uint16(…) → UInt16 | scalar | Convert to UInt16. | — |
to_uint16_or_default(…) → UInt16 | scalar | Convert to UInt16 (fallback default). | — |
to_uint16_or_null(…) → UInt16 | scalar | Convert to UInt16 (fallback null). | — |
to_uint16_or_zero(…) → UInt16 | scalar | Convert to UInt16 (fallback zero). | — |
to_uint256(…) → UInt256 | scalar | Convert to UInt256. | — |
to_uint256_or_default(…) → UInt256 | scalar | Convert to UInt256 (fallback default). | — |
to_uint256_or_null(…) → UInt256 | scalar | Convert to UInt256 (fallback null). | — |
to_uint256_or_zero(…) → UInt256 | scalar | Convert to UInt256 (fallback zero). | — |
to_uint32(…) → UInt32 | scalar | Convert to UInt32. | — |
to_uint32_or_default(…) → UInt32 | scalar | Convert to UInt32 (fallback default). | — |
to_uint32_or_null(…) → UInt32 | scalar | Convert to UInt32 (fallback null). | — |
to_uint32_or_zero(…) → UInt32 | scalar | Convert to UInt32 (fallback zero). | — |
to_uint64(…) → UInt64 | scalar | Convert to UInt64. | — |
to_uint64_or_default(…) → UInt64 | scalar | Convert to UInt64 (fallback default). | — |
to_uint64_or_null(…) → UInt64 | scalar | Convert to UInt64 (fallback null). | — |
to_uint64_or_zero(…) → UInt64 | scalar | Convert to UInt64 (fallback zero). | — |
to_uint8(…) → UInt8 | scalar | Convert to UInt8. | — |
to_uint8_or_default(…) → UInt8 | scalar | Convert to UInt8 (fallback default). | — |
to_uint8_or_null(…) → UInt8 | scalar | Convert to UInt8 (fallback null). | — |
to_uint8_or_zero(…) → UInt8 | scalar | Convert to UInt8 (fallback zero). | — |
to_unixtime(…) → UInt64 | scalar | Convert to Unix time. | — |
to_uuid(…) → UUID | scalar | Convert to UUID. | — |
to_uuid_or_default(…) → UUID | scalar | Convert to UUID (fallback default). | — |
to_uuid_or_null(…) → UUID | scalar | Convert to UUID (fallback null). | — |
to_uuid_or_zero(…) → UUID | scalar | Convert to UUID (fallback zero). | — |
to_valid_utf8(…) → String | scalar | Normalize text to valid UTF-8. | — |