Convert Julian dates in Normal date

Question

Convert Julian dates in Normal date

Vineet S 1,390

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-09-19T21:27:08.1166667+00:00

What is the expect result of these values? Or what is your definition of "Julian date"? (I looked it up in Wikipedia, but I am not sure that the article there has the same thing in mind as you have.)

Accepted answer

1 additional answer

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-09-19T21:27:08.1166667+00:00

What is the expect result of these values? Or what is your definition of "Julian date"? (I looked it up in Wikipedia, but I am not sure that the article there has the same thing in mind as you have.)

Answer 1

LiHongMSFT-4306 31,566

Hi @Vineet S

As far as I know, the Julian date is format as YYDDD, where YY means the two-digit form of the year and DDD means the DDDth day of that year.

Just wondering what normal date you want to convert from 12490, because 490 clearly exceeds the maximum number of days in a year.

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-23T18:31:08.2166667+00:00

Hi @Vineet S,

Just following up to see if you’ve had a chance to look into it further. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 2

Bruce (SqlWork.com) 77,686 Volunteer Moderator

simple expression:

declare @j int = 24263; -- 2024-09-19 in Julian
select  dateadd(dy, (@j % 1000) - 1, dateadd(yy, @j/1000, cast('2000-01-01' as date)))

Share via

Convert Julian dates in Normal date

1 additional answer

Your answer