String to Date&Time with Timezone Description

KNIME Analytics Platform
#1

Hi lovely all,

I’m trying to convert a string to datetime; after several attempts, it’s quite close but still gives me an error.

The original column has string values following the format 28-02-2019 20:22:37 AEDT, and I tried to convert it directly by selecting Date&Time with zone from the New type drop down; however, it gave me an error: Execute failed: Failed to parse date in row 'File0-Row5: Text ‘’ could not be parsed at index 0

image
image797×773 26.5 KB

File0-Row5 is my first row and the value is 28-02-2019 20:22:37 AEDT and I have double checked the value, it should not have any leading spaces.

Also, what I actually try to get is a Date&Time column rather then Date&Time with zone, but it seems that I’m not able to select Date&Time from the drop down due to the actual values detected. I know it’s possible to use String Manipulation to remove timezone description before converting, just wondering if there’s a way to achieve this directly using String to Date&Time.

Thanks and regards,
Olivia

#2

Try


It could work better for your case.

1 Like
#3

Hi @izaychik63,

It works perfectly, and just use Legacy Date&Time to Date&Time before further manipulation.

Thanks!
Olivia

#4

Hi there!

You need to convert both opened_at and resolved_u columns? If not maybe that is the reason node wasn’t able to parse at index 0.

For droping time zone there is Modify Time Zone node that should do the trick :wink:

Br,
Ivan

#5

Hi @ipazin,

Yes, I’m converting both two columns, and the node String to Date&Time (legacy) works good for me but not the default String to Date&Time.

Thanks for the trick! currently I’m just adding hours to show datetime in local time zone correctly.

Olivia

1 Like
#6

Hi @oliviaS!

I see. In that case both colums should have the same date format. If you can you can share a subset of data here so I can check if this is a configuration issue or a format issue :wink:

Br,
Ivan