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
Julian date in sybase to Date format
Moderators: chulett, rschirm, roy
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.
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.