Julian to gregorian Dates - TechRepublic
General discussion
November 26, 2008 at 12:59 AM
simonnd

Julian to gregorian Dates

by simonnd . Updated 17 years, 7 months ago

Hi All. I have a file with julian dates that needs to be imported in MS SQL and then convert the dates to gregorian. To extract the year is easy because I just use a left function but how would I get the month and day values? The date I have is 2008001 and I need it to be 2008/01/01. Anyone with any ideas?

This discussion is locked

All Comments