String to Date/Time different time shifts (over Days!)


hope someone has an idea what im doing wrong:

Im trying to convert a string to a time value, using the "String to Date/Time" knot.

My string is something like this: 2014-01-20 07:20:25.137000000

Inside the knot, I set the time format to:  yyyy-MM-dd HH:mm:ss.SSSSSSSSS

This is the result (string on the left, new date attribute on the right) :

(attached file)


Why differs the Date after (within Days!) ?

Did I use the wrong date format?

Thanks in advance,



I can't found the origin of your problem but the workflow in attachement does the job.

Best regards


The number of "S" in your pattern is definitely wrong. There can be at most 1000 milliseconds, otherwise it will flow over to seconds. Therefore you must not specify more than "SSS". If you have more millisecond digits in your date strings then it very likely something different.