format_time¶

Description¶

Format the timestamp value in UTC according to the specified format. Format specifiers are detailed in Snowflake’s time format specifiers documentation

string

This is a scalar function (calculates a single output value for a single input row.)

format_time( time, format )

Argument	Type	Required	Multiple	Constant
time	timestamp	Required	Only one	Variable
format	string	Required	Only one	Constant

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.