My i/p date is in the format yyyy-mm-dd.I want to convert in the format mmddyyyy.
Please suggest.Both the fields(i/p and o/p) datatype is Date.
date conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Dates, as you would have learned had you conducted a search, do not have any format - they are stored in binary format.
Date format strings specify how to convert between dates and string representations thereof.
Date format strings specify how to convert between dates and string representations thereof.
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.
If you are getting a "date" data type then the data is in internal binary form and the field actually has no format at all.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
A Date datatype has no format. How you display the Date column is dependant upon the display settings of your target system, that is where you need to look.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>