Converting Juilan Date To Datetime

Anonymous — Thu, 05 Jul 2012 09:38:02 GMT

Hi All,
I want to convert the julian date of format YYYDDD into YYYYMMDD.
My source file is EBCDIC so that column containing julian date is cuming as Packed value with data type BigDecimal.
So Please guide me how to convert this date to format YYYYMMDD

Re: Converting Juilan Date To Datetime

Anonymous — Thu, 05 Jul 2012 09:53:53 GMT

Hi
You might create a custom routine in TOS.

 public static java.util.Date juLianToDate(int date) {  
 int year = (date / 1000) + 1900;  
 int dayOfYear = date % 1000;  
 Calendar calendar = Calendar.getInstance();  
 calendar.set(Calendar.YEAR, year);  
 calendar.set(Calendar.DAY_OF_YEAR, dayOfYear);  
 return calendar.getTime();  
 }

Hope this help you.
Regards,
Pedro

topic Converting Juilan Date To Datetime in Talend Studio

Converting Juilan Date To Datetime

Re: Converting Juilan Date To Datetime