I would like to convert the date from 2008-10-07 to 07-OCT-2008.
I have tried to use DATE transform to convert the same.
I can convert the source Date (2008-10-07) to target as 07-10-2008.
But, My requirement is to display the Month in Chars rater than in Digits .
Please suggest me any good Mapping which can display Month in Characters.
Patrick Koehnen replied
you could use 3 substring functions.
In your example you will have:
The month value goes inside a FixValue function.
Then you concat your three substrings together.
If you do it like that you should check first if the length of input string is 10 chars.