date conversion

EJRoufs · Post by **EJRoufs** » Thu Oct 21, 2004 1:05 pm

We have a date coming in in the form of a 5 digit number. It's the number of days since 1900 (January 1, 1900 being 00001). Is there anything built into DataStage that would help with converting this to a more "standard" date that we can use? Or does anybody have something already written up that we could use that does this, or something similar that we could leverage off of?

Thanks in advance for any help! :>

ketfos · Post by **ketfos** » Thu Oct 21, 2004 1:55 pm

Hi,

Use Oconv function as

Oconv(Arg1-24835, "D")

Where Arg1 is your 5 digit date format e.g 000000

ketfos

EJRoufs · Post by **EJRoufs** » Thu Oct 21, 2004 1:59 pm

ketfos wrote:Hi,

Use Oconv function as

Oconv(Arg1-24835, "D")

Where Arg1 is your 5 digit date format e.g 000000

ketfos

Thanks! I actually just found the solution, though. DataStage has a built in function, DateDaysSince1900ToTimestamp, that does exactly what i'm looking for. Very neat, and simple! Who would have thought? :>