Date and time formats vary across different cultures and regions. The most commonly used date and time formats are based on the conventions established by the ISO, and various computing systems including Unix, Mac and Microsoft. Convert a date/time format from Unix, Mac, Microsoft, and Gregorian format to another.
Date and time formats are used to represent points in time. There are various formats available to display dates and times, and they can vary based on cultural, regional, or programming languages. Here are some common date and time formats:
This is an international standard for representing dates and times. It has the format: YYYY-MM-DDTHH:MM:SS. For example, "2023-12-05T14:30:00".
Gregorian format varies based on region, but a common format is DD/MM/YYYY for European, or MM/DD/YYYY for American. For example, "05/12/2023" or "12/05/2023".
Represents the number of seconds that have elapsed since January 1, 1970, at 00:00:00 UTC.
In Mac, date and time are represented number of seconds since January 1, 1904 at 00:00:00 UTC.
Microsoft represents date format in number of days since December 31, 1899. This format only represents date, not timestamp.
In Windows programming, FILETIME is a structure used to represent file times. It is a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC). FILETIME is commonly used in the Windows API for file operations.
The choice of format often depends on the context, the audience, and the specific requirements of the application or system being used. Different programming languages and systems may also have their own conventions for representing dates and times.