format_time¶
Description¶
Format a timestamp column according to the specified format string.
Format specifiers are detailed in Snowflake’s time format specifiers documentation
format_time can be used to extract elements of a time, such as the year or hour.
Timezone is always assumed to be UTC.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
format_time(time, format)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
time |
timestamp |
no |
no |
none |
format |
string |
no |
no |
constant |
Examples¶
make_col year:format_time(@."Valid From", "YYYY")
Extracts the year from the “Valid From” column
make_col formatted:format_time(@."Valid From", 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM')
Format the “Valid From” column according to ISO 8601
make_col formatted:format_time(@."Valid From", 'DY MON DD HH24:MI:SS YYYY')
Format the “Valid From” column similar to ctime’s format
make_col formatted:format_time(@."Valid From", 'MM/DD/YYYY HH12:MI:SS')
Format the “Valid From” column using US’s date format and a 12-hour clock.