Hi friends,
How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
Date convertions
Moderators: chulett, rschirm, roy
Is your input column a date field? If yes then no function is required, just change the date format in your target stage or at the project level if you want to stick to that format.
If your input column is a string, then one of the 'Date functions' is required, as Craig mentioned.
If your input column is a string, then one of the 'Date functions' is required, as Craig mentioned.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: