Home DFS SB OD SDN

Notice: How To Tip The Webmaster.


You are at the section Calendar History

Creating a Julian Period Day Database File

ColumnsStorage
1-8 (JPD, DWORD) Julian Period Day (the day that it will be at noon UTC) To get the time it was at 12AM, subtract 0.5; for 6AM, subtract 0.25; for 6PM, add 0.25; for 12AM the following day, add 0.5; for 6AM the following day, add 0.75.
9 Intentionally Left Blank
10 (WKDY, LONG) Weekday January 1 fell on. 0 = Mon, 1 = Tue, 2 = Wed, 3 = Thu, 4 = Fri, 5 = Sat, 6 = Sun. These values are stored in this file for easier visual checking of the accuracy of the formulas.
11 Intentionally Left Blank
12-16 (JCY, DWORD) Julian Calendar Year (NOT the Julian Period Year) + 20000. If the Julian Calendar Years are A.D. or C.E., then just add the 20000 and store it. For years that are B.C. or B.C.E. (note: this calendar has no year zero), take the absolute value of the year and subtract it from the value 20001. (Day 0 of the Julian Period Day has the year of 4713 B.C., stored as 20001 - 4713, or 15288; or think of 4713 B.C. as year -4712 and add that negative year to 20000 to get 15288).
17-19 (JCM, LONG) Julian Calendar Month + 100
20-22 (JCD, LONG) Julian Calendar Day of the Month + 100
23 Intentionally Left Blank
Julian Period Day ÷ 365.25

JPY = JPD / 365.25

24-28 (JPY, SINGLE) Julian Period Year (integer) (it's the Julian-1 Calendar Year plus 4712)
29-38 (JPY, SINGLE) Julian Period Year (decimal portion)
39 Intentionally Left Blank
Julian Period Day − (INT(Julian Period Day ÷ 365.25) × 365.25)

JPDY = JPD - (INT(JPD / 365.25) * 365.25)

40-42 (JPDY, SINGLE) Julian Period Day of the Year (integer)
43-52 (JPDY, SINGLE) Julian Period Day of the Year (decimal portion)
53 Intentionally Left Blank
Note: The Gregorian Period Day (GPD, DWORD) is always 38 days less than the Julian Period Day, so there's no need to store it in the database, but can be stored in a variable in a computer program for easier computing of the answers. This number is the offset of days that differ between the two proleptic Julian-1 and Gregorian calendars of the 48th century B.C. Like the JPD, the GPD day begins at noon the current day (decimal value is .0).
54-58 (GCY, DWORD) Gregorian Calendar Year (NOT the Gregorian Period Year) + 20000. If the Gregorian Calendar Years are A.D. or C.E., then just add the 20000 and store it. For years that are B.C. or B.C.E. (note: this calendar has no year zero), take the absolute value of the year and subtract it from the value 20001. (Gregorian Period Day zero, which is Julian Period Day 38, has the year of 4713 B.C., stored as 20001 - 4713, or 15288; or think of 4713 B.C. as year -4712 and add that negative year to 20000 to get 15288).
59-61 (GCM, LONG) Gregorian Calendar Month + 100
62-64 (GCD, LONG) Gregorian Calendar Day of the Month + 100
65 Intentionally Left Blank
(Julian Period Day − 38) ÷ 365.24218967

GPY = (JPD - 38) / 365.24218967

66-70 (GPY, SINGLE) Gregorian Period Year (integer) (may not always match the rate of the Gregorian Calendar Year, but its the Gregorian calendar year plus 4712)
71-80 (GPY, SINGLE) Gregorian Period Year (decimal portion)
81 Intentionally Left Blank
INT(Julian Period Day − 38) − (INT((Julian Period Day − 38) ÷ 365.24218967) × 365.24218967))

GPDY = (JPD - 38) - (INT((JPD - 38) / 365.24218967) * 365.24218967))

82-84 (GPDY, SINGLE) Gregorian Period Day of the Year (integer) (may not always match the Gregorian Calendar Day of the Year)
85-94 (GPDY, SINGLE) Gregorian Period Day of the Year (decimal portion)
95 Intentionally Left Blank
Note: The Hebrew Period Day (HPD, DWORD) is always 347997.25 (due to the fact that the new Hebrew day begins around sunset) days behind that of the Julian Period Day, so there's no need to store it in the database, but can be stored in a variable in a computer program for easier computing of the answers.

The epochic date, Tishrei 1, year 1, is equivalent to Monday, October 7, 3761 B.C.E. proleptic Julian-1 calendar or September 7, 3761 B.C.E. in the proleptic Gregorian calendar. October 7, 3761 B.C.E. Julian-Roman-1 is the equivalent of the Julian Period Day 347998, which began at 12:00 PM. The equivalent Hebrew date that corresponds to October 7, 3761 B.C.E. Julian-Roman-1 began at sunset or around 6PM on October 6, 3761 B.C.E. Julian-Roman-1 or Julian Period Day 347997.25, marking the start of Hebrew Period Day number 0.

When it was noon October 7, 3761 B.C.E., the Julian Period Day incremented to 347998.00 and the Hebrew Period Day incremented to 0.75, therefore, there is an offset of 347997.25 between the two Period Days.

This number is the offset of days that differ between the two proleptic Julian-1 and Hebrew calendars of the 48th century B.C. Unlike the JPD, the HPD day listed on the same row as the JPD begins at sunset (around 6pm) the evening before the current day (decimal value is .75 at noon the current day). For example, if the JPD is at noon, it ends with the .0, while the HPD at the same time ends at .75. When it's around 6pm or sunset, the JPD ends with a .25, but the HPD values has 1.0 added to the listed value. If it's 9pm, add .375 to the JPD and 1.125 to the HPD value.

96-100 (HCY, DWORD) Hebrew Calendar Year (NOT the Hebrew Period Year) + 20000.
101-103 (HCM, LONG) Hebrew Calendar Month (stored as 101-111 for the first months plus the leap month at 112, and 212 for the final month of the year)
104-106 (HCD, LONG) Hebrew Calendar Day of the Month + 100
107 Intentionally Left Blank
108-112 (HPY, SINGLE) Hebrew Period Year (integer)
113-122 (HPY, SINGLE) Hebrew Period Year (decimal portion)
123 Intentionally Left Blank
124-126 (HPDY, SINGLE) Hebrew Period Day of the Year (integer) (may not always match the Hebrew Calendar Day of the Year) (note: The Hebrew Period Day is lined up between the first day of the first year of the Hebrew calendar and the matching Julian Period Date, and the Hebrew Calendar does not necessarily match the Hebrew Period Year due to the calendar's design. The epochic date, 1 Tishrei year 1, is equivalent to Monday, October 7, 3761 B.C.E. proleptic Julian-1 calendar or September 7, 3761 B.C.E. in the proleptic Gregorian calendar.)
127-136 (HPDY, SINGLE) Hebrew Period Day of the Year (decimal portion)
137 Intentionally Left Blank
138-142 (MCY, DWORD) Martian Calendar of Earth Year + 20000 (calendar based on arbitrary rules for calendar set)
143-145 (MCM, LONG) Martian Calendar of Earth Month + 100 (stored as 101-124)
146-148 (MCD, LONG) Martian Calendar of Earth Day of the Month + 100
149 Intentionally Left Blank
Julian Period Day ÷ 686.97258

MCEY = JPD / 686.97258

150-154 (MCEY, SINGLE) Martian Calendar of Earth Year (integer) (based on Earth synodic days and Mars synodic year) (lines up at zero with Julian Period Day zero.)
155-164 (MCEY, SINGLE) Martian Calendar of Earth Year (decimal portion)
165 Intentionally Left Blank
Julian Period Day − (INT(Julian Period Day ÷ 686.97258) × 686.97258)

MCEDY = JPD - (INT(JPD / 686.97258) * 686.97258)

166-168 (MCEDY, SINGLE) Martian Calendar of Earth Day of the Year (integer)
169-178 (MCEDY, SINGLE) Martian Calendar of Earth Day of the Year (decimal portion)
179 Intentionally Left Blank
Julian Period Day ÷ 1.02749125170

MPMD = JPD / 1.02749125170

180-187 (MPMD, SINGLE) Martian Period of Mars Day (integer). Lines up at zero with Julian Period Day zero. Increments approximately by 0.9732 for every one increment of the Julian Period Day. (based on Mars synodic days and Mars synodic year)
188-197 (MPMD, SINGLE) Martian Period of Mars Day (decimal portion)
198 Intentionally Left Blank
Martian Period of Mars Day ÷ 668.592018

MPMY = MPMD / 668.592018

199-203 (MPMY, SINGLE) Martian Period of Mars Year (integer)
204-213 (MPMY, SINGLE) Martian Period of Mars Year (decimal portion)
214 Intentionally Left Blank
Martian Period of Mars Day − (INT(Martian Period of Mars Day ÷ 668.592018) × 668.592018)

MPMDY = MPMD - (INT(MPMD / 668.592018) * 668.592018)

215-217 (MPMDY, SINGLE) Martian Period of Mars Day of the Year (integer)
218-227 (MPMDY, SINGLE) Martian Period of Mars Day of the Year (decimal portion)
228 Intentionally Left Blank
?-end Future expansion
Menu:
Calendar History Main Page Calendar 1: The Romulus Calendar I Calendar 2: The Republican Calendar I Calendar 3: The Republican Calendar II Calendar 4: The Republican Transitional Calendar Calendar 5: The Julian-Roman-Actual-1 Calendar Calendar 6: The Julian-Roman-Transitional-1 Calendar Calendar 7: The Julian-Roman-1 Calendar Calendar 8: The Julian-Kalends-1 Calendar Calendar 9: The Julian-1 Calendar Calendar 10: The Gregorian Calendar Dual Dating Date Confusion Definition of Days on the Calendars Definition of Calendars: Others Old, New and Unknown Styles Leap Year Error on the Julian-Roman-Actual-1 Calendar What Calendars Each Country Was Using Gregorian-Julian Differences By Century New Years Days Addenda Day and Year Measurements Calendar Varieties-Gregorian Calendar Varieties-Julian Calendar Varieties-Other Years Converted From Julian Period Day Lining Up Julian Dates Between Earth and Mars The Martian Calendar of Earth Converting From the Julian Period Date Creating a Julian Period Day Database File Truncating Answers Conversion Between Julian-1 and Gregorian Calendars Create a Calendar Leap Year Day Comparisons Swedish Calendar 1700-1712 Fractions of Years, Etc.
Related:
Dave's Fun Stuff's Stuff Green Concepts Jesus' Date of Conception Calendar Coincidence Calendar History Units of Time Food to Lower Blood Pressure Fun With Money Electricity Rates Optical Illusions Celebrity Autographs Eat More Potassium! TV Died State Abbreviations Volume Measurements The 21 Factory Fun With Math Strip Unicode Mesa Silicon Cajon
Market Zone:
Dave's Fun Stuff
TV Zone:
Find your favorite TV shows with "Let's Watch TV!"
Notable:
Dave's Fun Stuff SDN Media News and More
Footer:
Dave's Fun Stuff Super Birthdays Contact Webmaster



© 1995-2023. davesfunstuff.com. All Rights Reserved. Reproduction of any part of this website without expressed written consent is prohibited.

Help Support Our Ad-Free Web Section

Just use our PayPal link to pay.

Please Donate Cash to help pay for webhosting, domain payments, expenses and labor in keeping this section going. Thank you.

$2, $5, $10, $20, $50, $75, $100, $ANY

Notice Of Disclosure (updated June 2023):

"David Tanny is the owner and operator of the domains davesfunstuff.com and davidtanny.com"

Website Cookie Policy