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??
Storing TimeStamp with MicroSeconds in a Varchar field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: