Presto Issue for Time conversion

[hitesh1907nayyar]

Require your help as stuck in time conversion in presto.

I have a epoch column with name timestamp as a string datatype and i want to convert this into date timestamp.

I have used the below query after reading through various blogs:

SELECT date_parse(to_iso8601(from_unixtime(CAST(timestamp AS bigint)) AS date ,
'%Y-%m-%dT%H:%i:%s.%fZ'))
FROM wqmparquet;
Everytime i run this query i get an error:

INVALID_FUNCTION_ARGUMENT: Invalid format: "2020-04-27T19:49:50.000Z" is malformed at "T19:49:50.000Z"

Can somebody please help me on this.

[mbasmanova]

@hitesh1907nayyar from_unixtime is all you need:SELECT from_unixtime(CAST(timestamp AS bigint)) FROM wqmparquet;