Hi, i m facing issue at
converting date (yyyy-mm-dd) to dd/mm/yyyy
converting date (dd-mon-yyyy) to dd/mm/yyyy
i tried unsuccessfully with convert function..
can any one came across such tasks?
Data conversion tasks
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They are fairly frequent requirements. However, Convert() would not be the correct function to use, as it effects character-by-character replacement. The actual solution will depend on the data type of the input column and the output column, but will involve some combination of DateToString() and StringToDate() with appropriate date format strings.
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.