Date and time formats converter
Calculator converts date and time from one format to another. Supports number of calendars (Hebrew, Julian, Islamic, Persian, Indian national, Kurdish, Afgan, Mayan) and also computer time (UNIX time and Excel time).

Calculations#

Gregorian calendar
Gregorian calendar (UTC)2024-11-14
14/11/2024
20241114
24/14/11
14 Nov 2024
2024
05:51:10 p.m.
05:51 p.m.
5:51 p.m.
17:51:10
17:51
17:51
UNIX family systems
UNIX timestamp as decimal number (32-bit)
(in seconds)
seconds since 1970-01-01
UNIX timestamp as hex number (32-bit)
(in seconds)
seconds since 1970-01-01
UNIX timestamp as decimal number (64-bit)
(in miliseconds)
miliseconds since 1970-01-01
UNIX timestamp as hex number (64-bit)
(in miliseconds)
miliseconds since 1970-01-01
Windows system
WINAPI timestamp as decimal number (64-bit)× 100 ns after 1610-01-01
WINAPI timestamp as hex number (64-bit)× 100 ns after 1610-01-01
Julian calendar
Julian daydays after 4713-01-01 B.C.
Modified Julian daydays after 1858-11-17
Julian calendar
Other calendars based on year/month/day system
Hebrew calendar (jewish)
Islamic calendar
Persian calendar
Kurdish calendar
Afghan calendar
Indian national calendar
Mayan calendar
Mayan long count calendar
Excel spreadsheet
Excel serial day
(PC, 1900 Date System)
days after 1900-01-01
Excel serial day
(Macintosh, 1904 Date System)
days after 1904-01-01
OLE Datedays after 1989-12-31
UUID
UUID Timestamp as decimal number (60-bit)× 100 ns after 1582-10-15
UUID Timestamp as hex number (60-bit)× 100 ns after 1582-10-15

Some facts#

  • Gregorian calendar (UTC*) - solar calendar introduced in 1582 by Gregory XIII pope. The base of this calendar is Julian calendar, which was used before. Made changes fixed delay related to tropical year. One year in Gregorian calendar has 365 days (or 366 for lap years) divided into 12 months. Name of the months were inherited from Julian calendar directly.
    *) UTC is an abbreviation of "Universal Time Coordinated" (Universal Coordinated Time). This calculator assumes that the time specified in the Gregorian calendar corresponds to the time zone "zero" (zero meridian, i.e. longitude 0, in London's Greenwich district).
  • UNIX timestamp - number of seconds from 1 January 1970 UTC. This date is known as begin of Unix epoch. This format is widely used to store time (and date) in UNIX family operating systems.
  • WINAPI timestamp - 64-bit timestamp used in Windows NT family OS-es. Also known as Active Directory timestamps, Win32 FILETIME, Win32 SYSTEMTIME, LDAP timestamp or NTFS time. Number of 100 nanosecond intervals since 1610-01-01.
  • Julian day - number of days from 1 January 4713 B.C., counted using Julian calendar. This date was determined by Joseph Scaliger in 1583 year. Julian days are widely used in astronomical calculations.
  • Modified Julian day - Julian day with start date moved to 17 November 1858 year. Modified Julian day can be simply computed from Julian day by subtracting 2400000,5 days from it.
  • Julian calendar - solar calendar invented by greck astronom Sosygenesa under Julius Cezar order. Introduced as official Rome calendar in 45 B.C. This calendar was widely used in whole Europe until Gregory calendar was invented in XVI century. Today, used for religious purposes - it's a base for liturgical year in the Orthodox Church.
  • Hebrew calendar - originally lunar (solar-lunar today) calendar, used by Semitic tribes. Most recent form was invented in 359 year by Sanhedryn under Hillela II order. One year in Hebrew calendar has 354, 355 or 356 days (383, 384 or 385 in lap years) divided into 12 or 13 months. Calendar begins at 7 October 3761 B.C. This date is known day creation of the world according to Jewish beliefs.
  • Islamic calendar - lunar calendar used mainly by Muslims for religious purposes. Calendar begins at 622 A.D. One year in Islamic calendar is divided into 12 months containing 29 or 30 days.
  • Persian calendar – calendar invented in Persia in XI century. Today, used in Afghanistan and Iran. Introduced in 1079 A.D. Persian calendar was developed among others by Omar Chajjama under Malik-Shah I sultan order. One year is divided into 12 months containings 30 or 31 days, excepting Esfand month, which has 29 days in non-leap years.
  • Kurdish calendar - solar calendar related to Persian calendar. It begins at 612 B.C.
  • Indian national calendar - calendar officially introduced in India at 22 March 1957 A.D. Developed 5 year before by Calendar Reform Committee under India government commision. Tere were many alternative calendars used in India, before Civil Indian calendar was introduced. One year in this calendar has 365 days (or 366 in leap years) divided into 12 months. Calendar begins at 78 A.D. to commemorate the victory over Saka.
  • Mayan long count - historical calendar used by Mayan civilization beetwen III and IX century. The date is five digit number recorded in twenty system, which means the number of days from 11 August 3113 B.C. Digits have names (from most significant): baktuns (144000 days weight), katuns (7200 days weight), tuns (360 days weight), uinals (20 days weight) and kins (1 day weight).
  • Excel serial day (PC, 1900) - time representation format used internally in Microsoft Excel software on PC computers (Windows). It's a number of days from 1 January 1900.
  • Excel serial day (Macintosh, 1904) - variation of Excel serial day with begin date moved to 1 January 1904. This format is used on Macintosh computers, because early version of MacOS systems had no support for dates before 1904 year.
  • OLE Date - format used in Microsoft applications, it's number of days since 31 December 1989 stored as 64-bit floating-point number (double datatype in C language).
  • UUID timestamp - 60-bit timestamp used in UUID version 1 and 2. Number of 100 nanosecond intervals since 1582-10-15 i.e. the beginning of the Gregorian calendar.

Tags and links to this website#

What tags this calculator has#

Permalink#

This is permalink. Permalink is the link containing your input data. Just copy it and share your work with friends:

Links to external sites (leaving Calculla?)#

Ancient version of this site - links#

In December 2016 the Calculla website has been republished using new technologies and all calculators have been rewritten. Old version of the Calculla is still available through this link: v1.calculla.com. We left the version 1 of Calculla untouched for archival purposes.
Direct link to the old version:
"Calculla v1" version of this calculator
JavaScript failed !
So this is static version of this website.
This website works a lot better in JavaScript enabled browser.
Please enable JavaScript.