Converting Julian dates to YYYYMMDD

srekant · Post by **srekant** » Fri Aug 29, 2008 8:22 am

Hi,

Can some one help me out on converting julian dates to YYYYMMDD format?

I/P dates are of format YJJJ and sample values are 8222 and 8225

Y-is the last digit of the year
JJJ-Number of the day in the year

Any help is appreciated

Raamc · Post by **Raamc** » Fri Aug 29, 2008 9:00 am

This is already discussed in this forum.

Refer the below link. This may helpfull to you

viewtopic.php?t=102387&highlight=julian+date

ray.wurlod · Post by **ray.wurlod** » Fri Aug 29, 2008 5:11 pm

How do you know to which year the y refers? Is it 1998, 2008, 2018 or something else (for example 8 years after some arbitrary zero year)? What will it be when your job executes in 2011 if y is 8 ?

<rant>
Who writes these specifications anyway? The need for this compression went away when disks became cheap, at least ten years ago!
</rant>