Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a sql load on my script and i would like to set a where condition based on the jualian date.
WHERE JulianDate > "Today minus 50 days"
how this can be done with Julian date? this will increase efficiency of the SQL that will load only data of the last 50 days
Thank you
My julian date is as follow:
118001 (is the first day of 2018 - 01/01/2018)
119001 (is the first day of 2019 - 01/01/2019)
119347
119= 2019
347= is the number of the day
the first 3 digit is retrieved in this way: 2019-1900 =119
2020 -1900 = 120
Got it. Thanks for the clarifications. You could try like:
Where Num(MakeDate(Left(JulianDate,3)+1900)+right(JulianDate,3)-1) > Num(Today()-50)