days_since_from_date
Posted: Tue Jul 15, 2008 1:52 am
Hi All,
Have requirement of to get number of days between two dates, have used date format as yyyy-mm-dd in DaysSinceFromDate function . While running datastage job , getting few warnings like : "DW_AcctArrg_Tfm1,4: Conversion error calling conversion routine days_since_from_date data may have been lost" .
I have checked that date value is yyyy-mm-dd only despite getting above message. Length is given int 32 in stage variable. This stage variable is being used in calculation of other fields.
Could you please guide on same to eliminate such problem. :(
Thanks in advanced
Have requirement of to get number of days between two dates, have used date format as yyyy-mm-dd in DaysSinceFromDate function . While running datastage job , getting few warnings like : "DW_AcctArrg_Tfm1,4: Conversion error calling conversion routine days_since_from_date data may have been lost" .
I have checked that date value is yyyy-mm-dd only despite getting above message. Length is given int 32 in stage variable. This stage variable is being used in calculation of other fields.
Could you please guide on same to eliminate such problem. :(
Thanks in advanced