Date convertions

mcs_suresh · Post by **mcs_suresh** » Thu Feb 28, 2008 10:30 am

Hi friends,

How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

chulett · Post by **chulett** » Thu Feb 28, 2008 10:38 am

Look up the various 'Date' functions, like DateFromString and StringFromDate off the top of my head.

DSguru2B · Post by **DSguru2B** » Thu Feb 28, 2008 1:28 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 2:19 pm

Are you being interviewed, or setting up a "prepare for interview" site?