writer
6,694
edits
Changes
Jump to navigation
Jump to search
Manuals/calci/GREGORIANDATE (view source)
Revision as of 23:44, 15 August 2017
, 23:44, 15 August 2017Created page with "<div style="font-size:30px">'''GREGORIANDATE (JulianDate)'''</div><br/> *<math>JulianDate</math> is any Julian date value. ==Description== *This function used to convert the ..."
<div style="font-size:30px">'''GREGORIANDATE (JulianDate)'''</div><br/>
*<math>JulianDate</math> is any Julian date value.
==Description==
*This function used to convert the Julian date in to Gregorian date format.
*In <math>GREGORIANDATE(JulianDate)</math>,<math>JulianDate</math> is any Julian date format.
*The Gregorian calendar is today's internationally accepted civil calendar and is also known as the Western or Christian calendar.
*The Gregorian calendar's predecessor, the Julian Calendar, was replaced because it was too inaccurate.
*It did not properly reflect the actual time it takes the Earth to circle once around the Sun, known as a tropical year.
*The Gregorian Calendar is the most widely used calendar in the world today.
*It is a solar calendar based on a 365-day common year divided into 12 months of irregular lengths.
*Eleven of the months have either 30 or 31 days, while the second month, February, has only 28 days during the common year.
*Also every four years a day is include on 29 February which is making the leap year in the Gregorian calendar.
*So Gregorian Calendar is having 366 days in leap year.
*Here Gregorian date values are converted in to Julian Date.
==Examples==
#GREGORIANDATE(2457980.5) = Tue, 15 Aug 2017 00:00:00 GMT
#GREGORIANDATE(2363216) = Wed, 01 Mar 1758 12:00:00 GMT
#GREGORIANDATE(2400000) = Tue, 16 Nov 1858 12:00:00 GMT
==See Also==
*[[Manuals/calci/JULIANDATE | JULIANDATE]]
*[[Manuals/calci/DATE | DATE]]
*[[Manuals/calci/EDATE | EDATE]]
==References==
*[https://www.timeanddate.com/calendar/gregorian-calendar.html Gregorian Date]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>JulianDate</math> is any Julian date value.
==Description==
*This function used to convert the Julian date in to Gregorian date format.
*In <math>GREGORIANDATE(JulianDate)</math>,<math>JulianDate</math> is any Julian date format.
*The Gregorian calendar is today's internationally accepted civil calendar and is also known as the Western or Christian calendar.
*The Gregorian calendar's predecessor, the Julian Calendar, was replaced because it was too inaccurate.
*It did not properly reflect the actual time it takes the Earth to circle once around the Sun, known as a tropical year.
*The Gregorian Calendar is the most widely used calendar in the world today.
*It is a solar calendar based on a 365-day common year divided into 12 months of irregular lengths.
*Eleven of the months have either 30 or 31 days, while the second month, February, has only 28 days during the common year.
*Also every four years a day is include on 29 February which is making the leap year in the Gregorian calendar.
*So Gregorian Calendar is having 366 days in leap year.
*Here Gregorian date values are converted in to Julian Date.
==Examples==
#GREGORIANDATE(2457980.5) = Tue, 15 Aug 2017 00:00:00 GMT
#GREGORIANDATE(2363216) = Wed, 01 Mar 1758 12:00:00 GMT
#GREGORIANDATE(2400000) = Tue, 16 Nov 1858 12:00:00 GMT
==See Also==
*[[Manuals/calci/JULIANDATE | JULIANDATE]]
*[[Manuals/calci/DATE | DATE]]
*[[Manuals/calci/EDATE | EDATE]]
==References==
*[https://www.timeanddate.com/calendar/gregorian-calendar.html Gregorian Date]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]