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:
Post a Comment