Where do I find it?
Configuration > Sales channels > Online-Shop (Desktop) > Integration
What does it mean?
There are different date and time formats you can use on your webshop. There are some of them well-known like dd-MM-yyyy, where dd is the day, MM the month and yyyy the year, but there are a few more allowed possibilities. Here we show all of them.
What should I do?
Patterns
The following patterns can be used in these webshop detail settings:
Apart from d, M and y, there are more allowed symbols to use as part of a date or time. Here you can find all of them and some examples in the following table:
| Symbol | Meaning | Presentation | Example |
|---|---|---|---|
G | era designator | Text | AD |
y | year | Number | 1996 |
L | standalone month in year | Text or Number | July (or) 07 |
M | month in year | Text or Number | July (or) 07 |
d | day in month | Number | 10 |
h | hour in am/pm (1-12) | Number | 12 |
H | hour in day (0-23) | Number | 0 |
m | minute in hour | Number | 30 |
s | second in minute | Number | 55 |
S | fractional second | Number | 978 |
E | day of week | Text | Tuesday |
c | standalone day of week | Text | Tuesday |
a | am/pm marker | Text | PM |
k | hour in day (1-24) | Number | 24 |
K | hour in am/pm (0-11) | Number | 0 |
z | time zone | Text | Pacific Standard Time(see comment) |
Z | time zone (RFC 822) | Text | -0800(See comment) |
v | time zone id | Text | America/Los_Angeles(See comment) |
' | escape for text | Delimiter | 'Date=' |
'' | single quote | Literal | 'o''clock' |
The number of pattern letters also influences the format, as follows:
- Text
- If you use 4 or more letters, then the date or time is shown as the full form; if you use less than 4 letters, then the date or time is shown as the short or abbreviated form if it exists (e.g.,
"EEEE"produces"Monday","EEE"produces"Mon"). - Number
- The minimum number of digits. Shorter numbers are zero-padded to this amount (e.g. if
"m"produces"6","mm"produces"06"). The year is handled specially; that is, if the count of 'y' is 2, the Year will be truncated to 2 digits. (e.g., if"yyyy"produces"20,"yy"produces"97".) Unlike other fields, fractional seconds are padded on the right with zero. - Text or Number
- If you use 3 or more letters, then it produces a text, otherwise, it produces the corresponding number. (e.g.
"M"produces"1","MM"produces"01","MMM"produces"Jan", and"MMMM"produces"January". Some pattern letters also treat a count of 5 specially, meaning a single-letter abbreviation:L,M,E, andc.
Any characters in the pattern that are not in the ranges of ['a '..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', ' .', ' ' (space), '#' and ' @' will appear in the resulting time text even they are not embraced within single quotes.
In the date, you may use "/", "-", or a space between the day, month, and year numbers. For example:
dd/MM/yyyyordd/MM/yydd-MM-yyyyordd-MM-yydd MM yyyyordd MM yy
Time Zone Handling
When you show a time string, for instance, your time departures, it is also possible to include information about the time zone. For formatting purposes, the following table shows the behavior of GWT DateTimeFormat.
| Pattern | Common TimeZone | Simple TimeZone |
|---|---|---|
| z, zz, zzz | PDT | UTC-7 |
| zzzz | Pacific Daylight Time | UTC-7 |
| Z, ZZ | -0700 | -0700 |
| ZZZ | -07:00 | -07:00 |
| ZZZZ | GMT-07:00 | GMT-07:00 |
| v, vv, vvv, vvvv | America/Los_Angeles | Etc/GMT+7 |
Examples
| Pattern | Formatted Text |
|---|---|
"yyyy.MM.dd G 'at' HH:mm:ss vvvv" | 2019.07.10 AD at 15:08:56 America/Los_Angeles |
"EEE, MMM d, ''yy" | Wed, July 10, '19 |
"h:mm a" | 12:08 PM |
"hh 'o''clock' a, zzzz" | 12 o'clock PM, Pacific Daylight Time |
"K:mm a, vvvv" | 0:00 PM, America/Los_Angeles |
"yyyyy.MMMMM.dd GGG hh:mm aaa" | 02019.July.10 AD 12:08 PM |
Parsing Considerations
When parsing a date string using the abbreviated year pattern ( "yy"), the parser must interpret the abbreviated year relative to some century. It does this by adjusting dates to be within 80 years before and 20 years after the time the parser instance is created. For example, using a pattern of "MM/dd/yy" and a date created on Jan 1, 2019, the string "01/11/21" would be interpreted as Jan 11, 2021, while the string "05/04/64" would be interpreted as May 4, 1964. During parsing, only strings consisting of exactly two digits will be parsed into the default century. If the year pattern does not have exactly two 'y' characters, the year is interpreted literally, regardless of the number of digits. For example, using the pattern "MM/dd/yyyy", "01/11/19" parses to Jan 11, 19 A.D.
When numeric fields about one another directly, with no intervening delimiter characters, they constitute a run of abutting numeric fields. Such runs are parsed specially. For example, the format "HHmmss" parses the input text "123456" to 12:34:56, parses the input text "12345" to 1:23:45, and fails to parse "1234". In other words, the leftmost field of the run is flexible, while the others keep a fixed width. If the parse fails anywhere in the run, then the leftmost field is shortened by one character, and the entire run is parsed again. This is repeated until either the parse succeeds or the leftmost field is one character in length. If the parse still fails at that point, the parse of the run fails.