Wednesday, May 23, 2007

How to make a julian date format( yyyyddd )

Sql script:
 
select
    convert(varchar,
                dateadd(d,
                               cast(right('2007265',3) as int)-1,
                                cast(left('2007265',4)+'0101' as datetime)
                               ) ,
               112) as the_date

No comments: