DFS MB SDN Stuff PIX CAL Home Stereos Snacks Batman Shop



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
Related:
Dave's Fun Stuff's Stuff Your Screen Size Electricity Rates HTML Colors Small Color Tables Large Color Tables Color Spans Creating CSS Colorful Link Buttons PC Keystroke Codes Eat More Potassium! State Abbreviations Intro to CSS D.T.'s Web Icons Optical Illusions Star Codes Windows Alt Codes Fun With Money Bits 'N' Bytes Celebrity Autographs TV Died Fast Food Fish Sandwich Reviews San Diego Apartment and Condo Maps Calendar History Jesus' Date of Conception Calendar Coincidence Software You Need DFS Bookmarks MikeMan Stupid Cat Videos Unicode Madness Unicode Tables Emoji Codes Alternative Letter Codes Unicode Country Flag Codes Game Piece Codes Dingbat Codes
Market Zone:
Amazon Shopping The DFS Market
TV Zone:
Find your favorite TV shows with "Let's Watch TV!"
Notable:
The Del: Dave's Entertainment Library! Celebrities a2z Hit Song Titles Stuff! Gregorian Calendar Collection Desktop Gregorian Calendar Collection (Mobile)-English Picture Gallery SDN Media News and More
Footer:
Dave's Fun Stuff Mega Birthdays Contact Webmaster





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

Website Cookie Policy