{{ $ref := ref . "maintenance/configurations.md" }}
Function Description
year(temporal-column [, precision])
Extract year from the input. Output is an INT value represent the year.
month(temporal-column [, precision])
Extract month of year from the input. Output is an INT value represent the month of year.
day(temporal-column [, precision])
Extract day of month from the input. Output is an INT value represent the day of month.
hour(temporal-column [, precision])
Extract hour from the input. Output is an INT value represent the hour.
minute(temporal-column [, precision])
Extract minute from the input. Output is an INT value represent the minute.
second(temporal-column [, precision])
Extract second from the input. Output is an INT value represent the second.
date_format(temporal-column, format-string [, precision])
Convert the input to desired formatted string. Output type is STRING.
now()
Get the timestamp when ingesting the record. Output type is TIMESTAMP_LTZ(3).