Azure SQL Database
An Azure relational database service.
5,623 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
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)))