conversion of date

consulting · Post by **consulting** » Fri Mar 28, 2008 5:34 am

is there any other way other than routine to convert date from mm-dd-yy to dd-mm-yy in server job

sachin1 · Post by **sachin1** » Fri Mar 28, 2008 5:36 am

you can use inbuilt function provided by datastage like "ICONV" and "OCONV"

WoMaWil · Post by **WoMaWil** » Fri Mar 28, 2008 6:08 am

there are many ways, depending on how much you can trust your date-data.

If MyDate is your Field

a

Mydate[4,3]:Mydate[1,3]:Mydate[7,2]

is just an other way without routine and inbuilt function.

consulting · Post by **consulting** » Fri Mar 28, 2008 6:22 am

thanks

DSXchange

conversion of date

conversion of date

Re: conversion of date