FunctionsType Conversion

to_interval_year

Constructs a year interval from numeric input and returns the signed year count.

to_interval_year(…) → Int64

Kind · scalar

Constructs a year interval from numeric input and returns the signed year count.

Part of the Type Conversion family.

to_interval_week

Constructs a week interval from numeric input and returns the signed week count.

to_ipv4

Converts values to canonical IPv4 text and returns NULL when conversion fails.