Storing TimeStamp with MicroSeconds in a Varchar field
Posted: Mon Aug 21, 2017 6:55 am
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??
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??