You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@flink.apache.org by lan tran <in...@gmail.com> on 2022/03/28 04:37:36 UTC

Date time convert

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](https://go.microsoft.com/fwlink/?LinkId=550986) for Windows