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