RSSAmplifier

Pat David · Oct 9, 2021

Converting Ordinal (Julian) Dates in SQL

0
Sign in to vote or save

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

I was recently put in charge of some (Microsoft SQL) databases for monitoring meteorological (and hydrological) data down here in Mobile Bay. One of the fun things I’ve found is that it’s apparently common to identify this data based on its ordinal day in the year. That is, a sequential count of the number of days since the first of that year. (Not to be confused with the Julian date…

Read on patdavid.net

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.