PARSE_TIME

The PARSE_TIME function is similar to PARSE_DATE except that the output of PARSE_TIME is a TIME.

Syntax

PARSE_TIME (time_string, format_string) 

Remarks

The format_string must not contain any DATE elements such as year, month, or day of month.

Example

PARSE_TIME ('23:59:31', 'hh24:mi:ss')

This results in a TIME value of 23:59:31.