Hi team,
Currently, I was facing this situation, I have the format string datetime like this "2018-03-29T07:39:49.722594Z". So how can I convert this into timestamp with local time zone ?
My current solution as cast as below
TO_TIMESTAMP(REPLACE(parcel.picked_up_date, 'T', ' '),'yyyy-MM-dd HH:mm:ss%z') AS p_picked_up_date,
However, Flink seem does not support the ‘%z’. Therefore, no data was casted through this ?
Best,
Quynh
Sent from Mail for Windows |
