Sun and Moon Astronomical Data for Programming


Before looking for our data format, we want to compare the Sun and Moon data with the book of The American Ephemeris for the 21st Century 2001 to 2050 at midnight by Neil F. Michelsen, a calendar bible for western astrology. The difference of two astronomical data should be within 1 minute, because some data without seconds. You will have strong confidence using our data.

 Sun and Moon Data

American Ephemeris September/October 2003

N - New Moon
C - Solar Center Point
S - Solar Sector Point

New Moon at 9/26 3:10 and 4/25 12:51
Libra at 9/23 10:48 and Scorpio at 9/23 20:10
Western Astrology doesn't have Solar Sector Point data

2003/01/02 20:23:00 N
2003/01/05 18:28:47 S
2003/01/20 11:53:39 C
2003/02/01 10:49:00 N
2003/02/04 06:06:25 S
2003/02/19 02:01:17 C
2003/03/03 02:35:00 N
2003/03/06 00:05:57 S
2003/03/21 01:00:50 C
2003/04/01 19:19:00 N
2003/04/05 04:53:33 S
2003/04/20 12:03:52 C
2003/05/01 12:15:00 N
2003/05/05 22:11:34 S
2003/05/21 11:13:29 C
2003/05/31 04:20:00 N
2003/06/06 02:20:48 S
2003/06/21 19:11:33 C
2003/06/29 18:39:00 N
2003/07/07 12:36:44 S
2003/07/23 06:05:13 C
2003/07/29 06:53:00 N
2003/08/07 22:25:23 S
2003/08/23 13:09:15 C
2003/08/27 17:27:00 N
2003/09/08 01:21:18 S
2003/09/23 10:47:53 C
2003/09/26 03:10:00 N
2003/10/08 17:01:37 S
2003/10/23 20:09:30 C
2003/10/25 12:51:00 N
2003/11/07 20:14:15 S
2003/11/22 17:44:26 C
2003/11/23 23:00:00 N
2003/12/07 13:06:14 S
2003/12/22 07:04:54 C
2003/12/23 09:44:00 N

The Sun and Moon Astronomical raw data is calculated by Universal Time (UT), a.k.a. Greenwich Mean Time (GMT). click for detail. We provide Visual Basic (VB) Programs with source codes to convert the data from UT to different time zones.

The following are sample data for your reference.

Moon

Full Moon Data is good for the application to find the Easter related holiday.

Sun

Mix Sun and New Moon Data

The VB program combines Sun and Moon Data in the Chinese Astronomical and Civil Calendar sequences from Different time zones.

Lunar Months

The VB program calculates the Chinese Astronomical and Civil Lunar Months from Different time zones.

Lunar Leap Months

The VB program lists Chinese Astronomical and Civil Lunar Leap Months with Double-Center-Point months from Different time zones. It also indicates the Fake Leap Months.

Another VB program compares the discrepancy about the assignment of Lunar Leap Months from different time zones.

Final Data in MS Access Database for Chinese Calendar

Final Sun Data

Simple Sun Table (SunKey) Sun Table with Date (T01)
Julian Day . Hour . Minute Julian Day . Year . Month . Day . Hour . Minute

20000060338
20000210527
20000360409
20000510031
20000651850
20000801209
20000950455
20001092217
20001241643
20001391316
20001541211

2000006076309200338
2000021076310050527
2000036076310200409
2000051076311040031
2000065076311181850
2000080076312031209
2000095076312180455
2000109076401012217
2000124076401161643
2000139076401311316
2000154076402151211

Final Moon Table

New Moon, Lunar Month, Leap Month Data (T02)
Julian Day . Lunar Month No . Leap Month . Hour. Minute . Civil Lunar Month . Civil Leap Month No
200002707630900145807630900
200005707631000013307631000
200008607631100141007631100
200011607631200044307631200
200014507640100203907640100
200017507640200131307640200
200020507640300054407640300
200023407640400213307640400
200026407640500120107640500
200029407640600004507640600
200032307640700114507640700
200035207640800213407640800

You can import the Sun and Moon data into Access, SQL, Oracle, MySQL, Sybase, or FoxPro database for your application. If you want to manipulate data in different format, then you can reformat the Sun and Moon raw data and sort the data sequence you want before loading into your database.

We provide some Visual Basic sample programs to work with the Sun and Moon data stored in the Microsoft Access Database.

Go to see the Sample Visual Basic Programs