15.4.10 timeformat(value1, value2)

Event Formatted time.

Value 1 can be one of the following types: timestamp.

Value 2 can be one of the following types: text.

Returned value will be of type text.

Function Result

timeformat(transaction_time, "M-dd-yy"), where calc is 12/19/2016 12:22:46

12-19-16

timeformat(transaction_time, "DAY"), where transaction_time is 12/19/2016 12:22:44 Monday