Hi,
How can I change date format from "YYYY-MM-DD" to "DD-MON-YY" in parallel jobs.
Thanks
Vinoth
Changing date format from YYYY-MM-DD to DD-MON-YY
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 62
- Joined: Thu Feb 08, 2007 6:01 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Date data types are stored in a binary form, so do not have formats.
To convert from one string representation to another, convert to and from Date data type with appropriate format strings. That is, use StringToDate() and DateToString() functions, assuming you're using a Transformer stage. Or date_from_string() and string_from_date() if you're using a Modify stage.
To convert from one string representation to another, convert to and from Date data type with appropriate format strings. That is, use StringToDate() and DateToString() functions, assuming you're using a Transformer stage. Or date_from_string() and string_from_date() if you're using a Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India