using sql server 2000, sp3
Hi all. I'm hoping someone out there has had to solve this problem before. I am attempting to convert dates that are formatted as YYYYDDD to datetime.
YYYY = Year
DDD = Day of year
I am planning on writing a udf to handle this conversion, but have been struggling with converting the day of year value into a month and day value.
Any help or suggestions would be greatly appreciated!
Thanks,
Jim
Hi all. I'm hoping someone out there has had to solve this problem before. I am attempting to convert dates that are formatted as YYYYDDD to datetime.
YYYY = Year
DDD = Day of year
I am planning on writing a udf to handle this conversion, but have been struggling with converting the day of year value into a month and day value.
Any help or suggestions would be greatly appreciated!
Thanks,
Jim