Julian date in sybase to Date format

gopskrish · Post by **gopskrish** » Tue May 17, 2005 10:05 am

Hi,

I am using sybase as my source and it is storing dates in integer format (internal to sybase). I want to pick up the value and then convert the same into date format using datastage. I hope there is a difference in the way sybase and datastage stores the first day (julian date).

Now i want to convert the integer format to date format using Parallex.

Do anyone know the actual formula for arriving the same. Do let me know.

cheers,
gop

ArndW · Post by **ArndW** » Tue May 17, 2005 10:18 am

gopskrish,

Parallel Extender does not use the DataStage engine, so it uses another format for the Julian date.

I am not at my system now, but you can write a quick dummy Px job to convert the current date to Julian and output the integer, then do the same in a Sybase query and see what the difference is.

gopskrish · Post by **gopskrish** » Tue May 17, 2005 10:22 am

Hi Andw,

Yeah. I will do that. If u get more details on that do let me know.
Thanks for the immediate response.

cheers,
gopskrish