date conversion plz advice

[bobby]

Hi,
please advice i have date in varchar want to change in Timestamp
12-oct-2004(varchar) to 2004-10-12 00:00:00 (Timestamp)
Thanks,
Bobby

[ArndW]

Hello Bobby,

you could use OCONV(ICONV(In.Date,"D4-DMY"),"D4-YMD[4,2,2]"):" 00:00:00". This will work for your sample but of course doesn't do any error checking in case the input date has an invalid format.

[ray.wurlod]

Spend some time learning about DataStage's date conversion functions. The paper Date Conversion Demystified is a good place to start.

Search the Forum; there are answers to your exact requirement to be found. Essentially you convert the incoming date into DataStage internal format, then convert that into exactly the output format you require. Add the time component using string concatenation.

[Rahul Reddy]

You can also change this date field to timestamp using an user defined SQL (if your source is a database). Else better to use ICONV and OCONV.

Hi,
please advice i have date in varchar want to change in Timestamp
12-oct-2004(varchar) to 2004-10-12 00:00:00 (Timestamp)
Thanks,
Bobby