Ordinal date

An ordinal date is a calendar date typically consisting of a year and an ordinal number, ranging between 1 and 366 (starting on January 1), representing the multiples of a day, called day of the year or ordinal day number (also known as ordinal day or day number). The two parts of the date can be formatted as "YYYY-DDD" to comply with the ISO 8601 ordinal date format. The year may sometimes be omitted, if it is implied by the context; the day may be generalized from integers to include a decimal part representing a fraction of a day.

Today's date (UTC) expressed according to ISO 8601 []
Date2023-10-26
Ordinal date2023-299
Mission control center's board with time data, displaying universal time with ordinal date (without year) prepended, on 22th October 2013 (i.e. 2013-295)

Nomenclature

Ordinal date is the preferred name for what was formerly called the "Julian date" or JD, or JDATE, which still seen in old programming languages and spreadsheet software. The older names are deprecated because they are easily confused with the earlier dating system called 'Julian day number' or JDN, which was in prior use and which remains ubiquitous in astronomical and some historical calculations.

Calculation

Computation of the ordinal day within a year is part of calculating the ordinal day throughout the years from a reference date, such as the Julian date. It is also part of calculating the day of the week, though for this purpose modulo 7 simplifications can be made.

In the following text, several algorithms for calculating the ordinal day O is presented. The inputs taken are integers y, m and d, for the year, month, and day numbers of the Gregorian or Julian calendar date.

Trivial methods

The most trivial method of calculating the ordinal day involves counting up all days that have elapsed per the definition:

  1. Let O be 0.
  2. From i = 1 .. m - 1, add the length of month i to O, taking care of leap year according to the calendar used.
  3. Add d to O.

Similarly trivial is the use of a lookup table, such as the one referenced.[1]

Zeller-like

The table of month lengths can be replaced following the method of encoding the month-length variation in Zeller's congruence. As in Zeller, the m is changed to m + 12 if m 2. It can be shown (see below) that for a month-number m, the total days of the preceding months is equal to ⌊(153 * (m 3) + 2) / 5⌋. As a result, the March 1-based ordinal day number is OMar = ⌊(153 × (m 3) + 2) / 5⌋ + d.

The formula reflects the fact that any five consecutive months in the range March–January have a total length of 153 days, due to a fixed pattern 31–30–31–30–31 repeating itself twice. This is similar to encoding of the month offset (which would be the same sequence modulo 7) in Zeller's congruence. As 153/5 is 30.6, the sequence oscillates in the desired pattern with the desired period 5.

To go from the March 1 based ordinal day to a January 1 based ordinal day:

  • For m 12 (March through December), O = OMar + 59 + isLeap(y) , where isLeap is a function returning 0 or 1 depending whether the input is a leap year.
  • For January and February, two methods can be used:
    1. The trivial method is to skip the calculation of OMar and go straight for O = d for January and O = d + 31 for February.
    2. The less redundant method is to use O = OMar 306, where 306 is the number of dates in March through December. This makes use of the fact that the formula correctly gives a month-length of 31 for January.

"Doomsday" properties:

With and gives

giving consecutive differences of 63 (9 weeks) for n = 2, 3, 4, 5, and 6, i.e., between 4/4, 6/6, 8/8, 10/10, and 12/12.

and gives

and with m and d interchanged

giving a difference of 119 (17 weeks) for n = 2 (difference between 5/9 and 9/5), and also for n = 3 (difference between 7/11 and 11/7).

Table

To the day of 13
Jan
14
Feb
3
Mar
4
Apr
5
May
6
Jun
7
Jul
8
Aug
9
Sep
10
Oct
11
Nov
12
Dec
i
Add 03159901201511812122432733043343
Leap years 03160911211521822132442743053352
Algorithm

For example, the ordinal date of April 15 is 90 + 15 = 105 in a common year, and 91 + 15 = 106 in a leap year.

Month–day

The number of the month and date is given by


the term can also be replaced by with the ordinal date.

  • Day 100 of a common year:
April 10.
  • Day 200 of a common year:
July 19.
  • Day 300 of a leap year:
November - 5 = October 26 (31 - 5).

Helper conversion table

ord.
date
common
year
leap
year
00101 Jan
01010 Jan
02020 Jan
03030 Jan
03201 Feb
04009 Feb
05019 Feb
06001 Mar29 Feb
06102 Mar01 Mar
07011 Mar10 Mar
08021 Mar20 Mar
09031 Mar30 Mar
09101 Apr31 Mar
09202 Apr01 Apr
10010 Apr09 Apr
ord.
date
comm.
year
leap
year
11020 Apr19 Apr
12030 Apr29 Apr
12101 May30 Apr
12202 May01 May
13010 May09 May
14020 May19 May
15030 May29 May
15201 Jun31 May
15302 Jun01 Jun
16009 Jun08 Jun
17019 Jun18 Jun
18029 Jun28 Jun
18201 Jul30 Jun
18302 Jul01 Jul
19009 Jul08 Jul
ord.
date
comm.
year
leap
year
20019 Jul18 Jul
21029 Jul28 Jul
21301 Aug31 Jul
21402 Aug01 Aug
22008 Aug07 Aug
23018 Aug17 Aug
24028 Aug27 Aug
24401 Sep31 Aug
24502 Sep01 Sep
25007 Sep06 Sep
26017 Sep16 Sep
27027 Sep26 Sep
27401 Oct30 Sep
27502 Oct01 Oct
28007 Oct06 Oct
ord.
date
comm.
year
leap
year
29017 Oct16 Oct
30027 Oct26 Oct
30501 Nov31 Oct
30602 Nov01 Nov
31006 Nov05 Nov
32016 Nov15 Nov
33026 Nov25 Nov
33501 Dec30 Nov
33602 Dec01 Dec
34006 Dec05 Dec
35016 Dec15 Dec
36026 Dec25 Dec
36531 Dec30 Dec
36631 Dec

See also

References

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.