Converting Julian date format to db2 format
Posted: Wed Oct 22, 2008 5:47 pm
Hi ,
I'm getting the Source as YYDDD i.e julian format from the csv (comma separated) file
Ex: 08046
08 -- 2008(year)
046-- day of the year(feb 15)
YYDDD as Varchar format
I need to convert in to db2 format(YYYY-MM--DD)
Pls help me on converting the julian format to date format
I'm getting the Source as YYDDD i.e julian format from the csv (comma separated) file
Ex: 08046
08 -- 2008(year)
046-- day of the year(feb 15)
YYDDD as Varchar format
I need to convert in to db2 format(YYYY-MM--DD)
Pls help me on converting the julian format to date format