INVALID_CAST_ARGUMENT: Value cannot be cast to date

I have column in Athena table as time -> string

I am trying to convert to datetime as below :

SELECT
     "source"
   , "account"
   , CAST(time as date) Datetime
   
   FROM
     "testdata"

It gives me below error:

INVALID_CAST_ARGUMENT: Value cannot be cast to date: 2021-11-28T08:04:21Z

>Solution :

Use DATE_PARSE:

SELECT source, account,
       DATE_PARSE(time, '%Y-%m-%dT%H:%i:%sZ') AS Datetime
FROM testdata;