Conversion error calling conversion routine date_from_julian

xogoblin · Post by **xogoblin** » Mon Oct 18, 2010 6:37 am

Hi,
I was designing a PX job which takes as input a Timestamp. Then i trasform this in a date with a timestamptodate. Then I tried using the DateFromJulianDay function in my transformer but when i run this job, it is return me this error:

Conversion error calling conversion routine date_from_julian

All suggestions are welcome.
Thanks.

chulett · Post by **chulett** » Mon Oct 18, 2010 6:50 am

What is your ultimate goal here? You said you already converted your timestamp to a date which is why the DateFromJulianDay() function fails - you don't have a julian day for it to convert to a date.

xogoblin · Post by **xogoblin** » Mon Oct 18, 2010 7:13 am

I try to explane better.

My date is a Timestamp. In my trasformer I create a Variable stage called ERIPinival. The derivation is
JulianDayFromDate(timestamptodate(in_D_EDW_EAUT.DATA_ERIP_DATA_INI_VAL)). Then i assigned this Variable to another variable stage called MAXinival. The derivation is DateFromJulianDay(max(ERIPinival)). And a the end I assign this variable tu a column date in trasformer. when i tried to run the job it returns the error