Amazon Kinesis Data Analytics
SQL Reference

CHAR_TO_DATE

Converts a string to a date, according to the specified format string.

CHAR_TO_DATE(format,dateString);