Difference between revisions of "Manuals/calci/GREGORIANDATE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created 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 ...")
 
 
Line 19: Line 19:
 
#GREGORIANDATE(2363216) = Wed, 01 Mar 1758 12:00:00 GMT
 
#GREGORIANDATE(2363216) = Wed, 01 Mar 1758 12:00:00 GMT
 
#GREGORIANDATE(2400000) = Tue, 16 Nov 1858 12:00:00 GMT
 
#GREGORIANDATE(2400000) = Tue, 16 Nov 1858 12:00:00 GMT
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=xUHyU5CsZ6w|280|center|Gregorian Date}}
  
 
==See Also==
 
==See Also==

Latest revision as of 15:21, 11 February 2019

GREGORIANDATE (JulianDate)


  • is any Julian date value.

Description

  • This function used to convert the Julian date in to Gregorian date format.
  • In , 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

  1. GREGORIANDATE(2457980.5) = Tue, 15 Aug 2017 00:00:00 GMT
  2. GREGORIANDATE(2363216) = Wed, 01 Mar 1758 12:00:00 GMT
  3. GREGORIANDATE(2400000) = Tue, 16 Nov 1858 12:00:00 GMT

Related Videos

Gregorian Date

See Also

References