The format refers to date or numerical fields.
Language
You can prefix the format with the desired language indicator using ISO standard 639:1988.
The default language is "en."For dates, this has an impact on month names, numerical values, and the decimal separator.
Viewing the export format
The "Results" column of the conversion form allows you to view the data in the exported format:
- If no conversion is applied to the data, simply put $ in "Conversion" and then fill in test data.
- For a date, the test data must be in the format yyyy-mm-dd hh:mm:ss.
- For a numerical value, the separator in the test data must be a period.
Examples:
Format
Conversion
Test data
Result
hh 'hour' a, zzzz $ 2001-07-04 02 hour AM, Central European Summer Time fr|hh 'heure' a, zzzz $ 2001-07-04 02 heure AM, Heure d'été d'Europe centrale fr|0,000.00 Math.round($*100/3)/100 20 0,006.67
A date format is written using the following symbols:
|
Symbol |
Date component |
Examples |
| G | Era | AD |
| y | Year | 1996, 96 |
| M | Month of the year, from 1 to 12 | July, Jul, 07 |
| w | Week of the year | 27 |
| W | Week of the month | 2 |
| D | Day of the year | 189 |
| d | Day of the month | 10 |
| F | Day of the week | 2 |
| E | Day of the week, as text | Tuesday, Tue |
| a | ante meridiem/post meridiem | PM |
| H | Hour of the day (from 0 to 23) | 0 |
| k | Hour of the day (from 1 to 24) | 24 |
| K | Hour of the half-day (from 0 to 11) | 0 |
| h | Hour of the half-day (from 1 to 12) | 12 |
| m | Minute of the hour | 30 |
| s | Second of the minute | 55 |
| S | Milliseconds | 978 |
| z | General time zone | PST, GMT-08:00 |
| Z | RFC 822 time zone | -0800 |
Examples:
Formats applied to the date 2001-07-04 12:08:56. Time shifting is linked to application of the time zone (see Settings).
Format
Result
dd/MM/yyyy 04/07/2001 yyyy.MM.dd '-' HH:mm:ss z 2001.07.04 - 14:08:56 CET h:mm a 2:08 PM fr|hh 'heure' a, zzzz 02 heure AM, Heure d'Europe centrale hh 'hour' a, zzzz 02 hour AM, Central European Summer Time K:mm a 2:08 PM yyyyy.MMMMM.dd GGG hh:mm aaa 02001.July.04 AD 02:08 PM fr|yyyyy.MMMMM.dd GGG hh:mm aaa 02001.juillet.04 ap. J.-C. 02:08 PM EEE, d MMM yyyy HH:mm:ss Wed, 4 Jul 2001 02:08:56 yyMMddHHmmss 010704020856
As default, the format of numerical values follows English usage. The decimal separator is therefore a period.
In order for the decimal separator to be a comma, as is customary in French, prefix the format with "fr| ."
A numerical value format is written using the following symbols:
|
Symbol |
Date component |
| 0 | Figure |
| # | Figure, 0 not displayed |
| . | Decimal separator |
| - | "Minus" sign |
| , | Group separator |
| E | Prefix for the exponent in scientific notation |
| ; | Separation of positive and negative formats |
| % | As a prefix or suffix, multiplies the number by 100 and displays it as a percentage |
| ' | In order for the following or preceding symbol not to be interpreted |
Examples:
Formats applied to the numerical value 123.456.
Format
Result
fr|0.###E0 1,235E2 ##0.#####E0 123.456E0 00000.##E0 12345.6E-2 #% 12346% fr|0,000.00 0,123.56 # 123 fr|#.##€ 123,46€