Column consist data in date time zone but in string data type want to convert it into single time date zone along with date&time datatype

Hi All

I have a data in below format
image
First thing column is in string format
second data have UTC and GMT data

First thing I want to have same time zone throughout the column and second want to convert string to date&time format

I tried to to convert string to data& time node and data&time shift but it throws error

Hi @Vinay1995

See this wf
time_zone.knwf (20.9 KB)

The Modify Time Zone is configured to remove the time zone from the DateTime column. But you can also adjust the DateTime to timezone you like.
image


gr. Hans

1 Like