Error: Invalid timestamp: '2017/05/16 19:33:49' BIGQUERY

Question

I have a string '2017/05/16 19:33:49' and I'm getting an error when I try to convert it to the TIMESTAMP:

Error: Invalid timestamp: '2017/05/16 19:33:49'

I want to use CAST function to convert it to TIMESTAMP. How can I do it?

Answer 1

Try this:

SELECT CAST("2017/05/16 19:33:49" AS DATETIME);

Answer 2

SELECT PARSE_TIMESTAMP("%Y/%m/%d %H:%M:%S", "2017/05/16 19:33:49") as parsed;