Hi all,
I have to convert the date format "yyyy-mm-dd" to "dd-mon-yyyy"
where my job looks like
SEQ.FILE----- TRANSFORMER STAGE----- SEQ.FILE
Please anybody help me out.
Thanks in advance
date format conversion
Moderators: chulett, rschirm, roy
date format conversion
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
It is marked duplicate in other post. Hence I belive Moderater can move this one to Parallel and can delete the other post.
Raji - Try StringToDate() function. What is you input stage. If is sequential file, read the input data field as varchar and use StirngToDate in the transformer.
Raji - Try StringToDate() function. What is you input stage. If is sequential file, read the input data field as varchar and use StirngToDate in the transformer.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'