{{ $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). |