15.2.7 string(value1, value2)

Conversion to string.

Value 1 can be one of the following types: intervalym, big integer, number, boolean, double, interval, integer, float, timestamp. Required.

Value 2 is output date format. It's required argument for value1 of type timestamp. Value can be one of the following types: text. Optional.

Returned value will be of type text.

Function Result

string(transaction_time,"hh-mm-ss") , where transaction_time is 12/19/2016 12:23:04

12-23-04

string(transaction_time,"M-DD-YY") , where transaction_time is 12/19/2016 12:23:04

12-19-16