Drag and drop a format-dateTime function in Transformation
In picture you will specify what is the format you want your output to be
"[Y0001]-[M01]-[D01]-[H01].[m01].[s01].[f000001]"
it will produce an output in 2000-12-11-12.12.23.120000
Similarly you can change the picture to produce output in your required format.
No comments:
Post a Comment