conventions for date representation around the world
The legal and cultural expectations for date and time representation vary between countries, and it is important to be aware of the forms of all-numeric calendar dates used in a particular country … Wikipedia
🌐
Wikipedia
en.wikipedia.org › wiki › List_of_date_formats_by_country
List of date formats by country - Wikipedia
3 days ago - Writers have traditionally written abbreviated dates according to their local custom, creating all-numeric equivalents to day–month formats such as "10 March 2026" (10/03/26, 10/03/2026, 10-03-2026 or 10.03.2026) and month–day formats such as "March 10, 2026" (03/10/26 or 03/10/2026).
🌐
Oracle
docs.oracle.com › cd › E41183_01 › DR › Date_Format_Types.html
Date Format Types
You are here: Function Reference > Date Functions > Date Formats > Date Format Types
Discussions

java - What are the date formats available in SimpleDateFormat class? - Stack Overflow
Can anybody let me know about the date formats available in SimpleDateFormat class. I have gone through api but could not find a satisfactory answer.Any help is highly appreciated. More on stackoverflow.com
🌐 stackoverflow.com
"Metric" date formats

It's also worth noting that ISO8601 also uses the 24-hour clock, thus eliminating any confusion from statements such as

Please submit your final thesis by 05/04/13 before 12:00

More on reddit.com
🌐 r/Metric
22
37
May 20, 2011
CMV: YYYY-MM-DD is the superior date format
There is something to be said for presenting the most useful information first. We typically don't need to say the year. For example, If i told you I was going to do something January 10th, you would know what I mean. We also don't ways need to say the month. If i told you i'd do something on the 21st, you'd assume i'm meant the 21st of this month. So we we start with the most relevant information first, there a decent debate to be had over whether we should say the day or the month first. But definitely the year is not very relevant. Very often we only need MM/DD or DD/MM. YYYY/xx/xx is a waste of some space. Especially when speaking. In terms of sorting, most of the time dates are stores as dates and rendered in any format selected. So you can sort properly regardless of format. YYYY-MM-DD has its place. Its good when communicating between different applications which don't share a common data structure. Like between Excel and a database. Its also good when embedded into text fields which you want to sort. Although really you shouldn't be doing that. More on reddit.com
🌐 r/changemyview
101
26
December 13, 2018
Dd/mm/yyyy is the correct way to write a date
Popular opinion on literally the rest of the world but the US More on reddit.com
🌐 r/unpopularopinion
993
6984
April 28, 2018
🌐
Churbuck
churbuck.com › 2019 › 05 › 17 › date-formats
Date Formats – Churbuck.com
May 17, 2019 - MDY: Month-Day-Year: This is the U.S. format (also used in the Philippines and English-speaking Canada): May 17, 2019 or 05-17-2019 or 5/17/19/ YDM: Year-Day-Month: 2019.17.05 or 2019 17 May.
🌐
Microsoft Learn
learn.microsoft.com › en-us › dotnet › standard › base-types › standard-date-and-time-format-strings
Standard date and time format strings - .NET | Microsoft Learn
A standard date and time format string uses a single character as the format specifier to define the text representation of a DateTime, DateTimeOffset, DateOnly, or TimeOnly value. Any date and time format string that contains more than one character, including white space, is interpreted as a custom date and time format string.
🌐
Estima
estima.com › webhelp › topics › dateformat.html
Date Formats
On input, RATS assumes the components are in the order year, month, day or year, period and allows a wide variety of delimiters (: - / . Q M or P). If you have anything else, you can use the DATEFORM option to let RATS know how to interpret the date string. In the date format string, use y for positions with the year, m for position with the month and d for positions with the day.
Find elsewhere
🌐
IBM
ibm.com › docs › en › i › 7.4.0
Date formats
There is no worldwide standard for the presentation of dates. Therefore, the date format should always be stored externally as part of the textual data.
🌐
Wikipedia
en.wikipedia.org › wiki › ISO_8601
ISO 8601 - Wikipedia
1 week ago - The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred between countries with different conventions for writing numeric dates and times. ISO 8601 applies to these representations and formats: dates, in the Gregorian calendar (including the proleptic Gregorian calendar); times, based on the 24-hour timekeeping system, with optional UTC offset, time intervals, and combinations thereof.
🌐
Umango
umango.com › img › content › knowledge_base › DateTimeFormats.pdf pdf
Date and Time Formats
Explore Umango's document solutions that are tailored for businesses seeking growth and efficiency. Use our cutting-edge AI technology to empower your business to thrive in the digital age.
🌐
Unicode
cldr.unicode.org › translation › date-time › date-time-patterns
Date/Time Patterns
April 1, 2025 - A letter in the set {a-z; A-Z} indicates the type of calendar field: See Date/Time Symbols. ... The number of letters indicate the form of the names to be used. ... Numeric representation: M or MM for 9 or 09, with leading 0. This is intended to be used in conjunction with a day number; thus, 9/12 or 09/12 ... When formatting a particular date, non-numeric values (e.g.
🌐
W3Schools
w3schools.com › js › js_date_formats.asp
W3Schools.com
The ISO 8601 syntax (YYYY-MM-DD) is also the preferred JavaScript date format:
🌐
Python documentation
docs.python.org › 3 › library › datetime.html
datetime — Basic date and time types
Return a time corresponding to a time_string in any valid ISO 8601 format, with the following exceptions: Time zone offsets may have fractional seconds. The leading T, normally required in cases where there may be ambiguity between a date and a time, is not required.
🌐
ISO
iso.org › iso-8601-date-and-time-format.html
ISO - ISO 8601 — Date and time format
ISO 8601 is the internationally accepted way to represent dates and times.
🌐
Enovapoint
help-jungledocs.enovapoint.com › jungledocs documentation › date formatting formulas
Date formatting formulas - JungleDocs Documentation
Date formatting is very simple in JungleDocs: all you need to know is how to use date and time format strings. A date and time format string defines the text representation of a DateTime or DateTimeOffset value that results from a formatting operation.
Top answer
1 of 4
191

Date and time formats are well described below

SimpleDateFormat (Java Platform SE 7) - Date and Time Patterns

There could be n Number of formats you can possibly make. ex - dd/MM/yyyy or YYYY-'W'ww-u or you can mix and match the letters to achieve your required pattern. Pattern letters are as follow.

  • G - Era designator (AD)
  • y - Year (1996; 96)
  • Y - Week Year (2009; 09)
  • M - Month in year (July; Jul; 07)
  • w - Week in year (27)
  • W - Week in month (2)
  • D - Day in year (189)
  • d - Day in month (10)
  • F - Day of week in month (2)
  • E - Day name in week (Tuesday; Tue)
  • u - Day number of week (1 = Monday, ..., 7 = Sunday)
  • a - AM/PM marker
  • H - Hour in day (0-23)
  • k - Hour in day (1-24)
  • K - Hour in am/pm (0-11)
  • h - Hour in am/pm (1-12)
  • m - Minute in hour (30)
  • s - Second in minute (55)
  • S - Millisecond (978)
  • z - General time zone (Pacific Standard Time; PST; GMT-08:00)
  • Z - RFC 822 time zone (-0800)
  • X - ISO 8601 time zone (-08; -0800; -08:00)

To parse:

2000-01-23T04:56:07.000+0000

Use: new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ");

2 of 4
55

Let me throw out some example code that I got from http://www3.ntu.edu.sg/home/ehchua/programming/java/DateTimeCalendar.html Then you can play around with different options until you understand it.

import java.text.SimpleDateFormat;
import java.util.Date;

public class DateTest {
   public static void main(String[] args) {
       Date now = new Date();

       //This is just Date's toString method and doesn't involve SimpleDateFormat
       System.out.println("toString(): " + now);  // dow mon dd hh:mm:ss zzz yyyy
       //Shows  "Mon Oct 08 08:17:06 EDT 2012"

       SimpleDateFormat dateFormatter = new SimpleDateFormat("E, y-M-d 'at' h:m:s a z");
       System.out.println("Format 1:   " + dateFormatter.format(now));
       // Shows  "Mon, 2012-10-8 at 8:17:6 AM EDT"

       dateFormatter = new SimpleDateFormat("E yyyy.MM.dd 'at' hh:mm:ss a zzz");
       System.out.println("Format 2:   " + dateFormatter.format(now));
       // Shows  "Mon 2012.10.08 at 08:17:06 AM EDT"

       dateFormatter = new SimpleDateFormat("EEEE, MMMM d, yyyy");
       System.out.println("Format 3:   " + dateFormatter.format(now));
       // Shows  "Monday, October 8, 2012"

       // SimpleDateFormat can be used to control the date/time display format:
       //   E (day of week): 3E or fewer (in text xxx), >3E (in full text)
       //   M (month): M (in number), MM (in number with leading zero)
       //              3M: (in text xxx), >3M: (in full text full)
       //   h (hour): h, hh (with leading zero)
       //   m (minute)
       //   s (second)
       //   a (AM/PM)
       //   H (hour in 0 to 23)
       //   z (time zone)
       //  (there may be more listed under the API - I didn't check)

   }

}

Good luck!

🌐
Tableau
help.tableau.com › current › api › webdataconnector › en-us › docs › wdc_ref_date_formats.html
Supported Date Formats
For information about the symbols used in these format examples, see Formatting Dates and Times on the ICU User Guide site.
🌐
Dromo
dromo.io › glossary › standardizing-date-formats
Standardizing Date Formats
Locale: Different locales have different conventional date formats.