Transform string format whith month into timestamp in datastage

Question

I want transform the string Thu, 21 Jan 2021 09:48:38 +0100 in timestamp format "%yyyy-%mm-%dd %hh.%nn.%ss.6"

how to do?

Thank you

Answer 1

Check out the StringToTimestamp function and the other type conversion functions in DataStage.

You could also work with string manipulation first. Note that you have not provided the information about the fraction of the second yet.