DSXchange

Hi guys,

I am getting XML message for my source data which has a TIME attribute with value like "2017-08-18T16:00:54.368+01:00"

I have extracted this value from the XML and stored in a field in transformer with datatype as varchar and the value after peeking into it was
"2017-08-1816:00:54.368"

So this is fine - i am happy with it.

Now, the thing is I want to change the format of this data into %dd-%mmm-%yyyy%hh%nn%ss.3

I have tried many conversions but this format change is not happening and the microseconds value gets dropped and gets replaced with '000'.

Any ideas guys how we can do this??

So... how exactly are you attempting to change the format? Does it involve an actual timestamp field, perhaps one that doesn't have microseconds enabled?

Have you tried TimestampToString() nested inside StringToTimestamp() ?