Package dev.frostlake.functions.scalar.conversion

package dev.frostlake.functions.scalar.conversion
  • Class
    Description
    BinaryAsString
    BINARY_AS_STRING(bin) — the binary input's bytes interpreted as UTF-8 text.
    Cast
     
    DateFunction
    DATE(<expr>) — the alias of TO_DATE that ALSO accepts an epoch NUMBER.
    NumericFormatElement
    One element of a numeric input format model, as NumericFormatModel scans it.
    NumericFormatModel
    A numeric INPUT format model — the format argument of TO_NUMBER / TO_DECIMAL / TO_NUMERIC, TO_DOUBLE and TO_DECFLOAT over a text, and of their TRY_ twins — scanned into its alternatives and checked the way the account checks it, before the text is read.
    StringAsBinary
    STRING_AS_BINARY(s) — the string's UTF-8 bytes as BINARY.
    TimeFunction
    TIME(<expr>) — the TIME synonym, which is not TO_TIME.
    TimestampFlavourConversion
    The one conversion behind TO_TIMESTAMP and its TRY_ twins, handing back the value the call's flavour holds: a TIMESTAMP_NTZ is a wall clock, a TIMESTAMP_LTZ the instant the input names shown in the session's zone, and a TIMESTAMP_TZ that instant at an offset it keeps.
    ToBinary
    TO_BINARY(string [, format]) — decodes the input string into a BinaryValue using format (default HEX).
    ToBoolean
     
    ToChar
     
    ToDate
     
    ToDecfloat
    TO_DECFLOAT(expr [, format]) — a 38-digit decimal float on the account, carried here as a DOUBLE, the engine's stand-in for DECFLOAT (a DECFLOAT column is one too).
    ToDouble
    TO_DOUBLE(expr [, format]).
    ToNumber
     
    ToTime
    TO_TIME(expr [, format]).
    ToTimestamp
    TO_TIMESTAMP / TO_TIMESTAMP_LTZ / TO_TIMESTAMP_TZ.
    ToTimestampNtz
     
    ToUuid
    TO_UUID(s) — the canonical lowercase form of a UUID string.
    TryCast
    Catalog entry for TRY_CAST.
    TryToBinary
    TRY_TO_BINARY(expr [, format]) — the non-throwing form of TO_BINARY: delegates to ToBinary (HEX default / BASE64 / UTF-8) and returns NULL instead of raising when the input cannot be decoded.
    TryToBoolean
     
    TryToDate
     
    TryToDecfloat
    TRY_TO_DECFLOAT(expr [, format]) — ToDecfloat answering NULL where TO_DECFLOAT fails on the value: a text that spells no number, a format model the text does not fit, and a model that is not one.
    TryToDouble
    TRY_TO_DOUBLE(expr [, format]) — ToDouble answering NULL where TO_DOUBLE fails on the value.
    TryToNumber
    TRY_TO_NUMBER / TRY_TO_DECIMAL / TRY_TO_NUMERIC — TO_NUMBER's full signature (expr [, format] [, precision, scale]) returning NULL instead of erroring, INCLUDING the scale handling: with no scale the result rounds to a whole number like TO_NUMBER's NUMBER(38,0) default.
    TryToTime
    TRY_TO_TIME(expr [, format]) — the non-throwing form of TO_TIME: delegates to ToTime and returns NULL instead of raising when the input cannot be parsed as a time.
    TryToTimestamp
    TRY_TO_TIMESTAMP / _NTZ / _LTZ / _TZ — the non-throwing form of TO_TIMESTAMP: the same conversion into the same flavour's value (see TimestampFlavourConversion), NULL instead of a refusal for input it cannot read.
    TryToUuid
    TRY_TO_UUID(s) — TO_UUID that returns NULL instead of erroring.