FunctionsType Conversion

cast_as_text

Casts the input value to UTF-8 text representation.

cast_as_text(…) → String

Kind · scalar

Casts the input value to UTF-8 text representation.

Part of the Type Conversion family.

cast_as_smallint

Casts the input value to 16-bit signed range. Out-of-range values yield NULL.

cast_as_time

Casts values to time-of-day text in HH:MM:SS form. Accepts timestamps, integer seconds-of-day, and parseable time strings.