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
|