Для форматирования дат в таких функциях как formatDate() необходимо использовать идентификаторы из таблицы ниже.
Примеры:
formatDate(today(), ‘Y‘) = 2025
formatDate(‘2025-03-06‘, ‘dd/MM/Y‘) = 06/03/2025
| Единица | Паттерн | Результат |
|---|---|---|
| Эра | G..GGG | AD, BC |
| GGGG | Anno Domini, Before Christ | |
| GGGGG | A, B | |
| Календарный год | y | 44, 1, 1900, 2017 |
| yo | 44th, 1st, 0th, 17th | |
| yy | 44, 01, 00, 17 | |
| yyy | 044, 001, 1900, 2017 | |
| yyyy | 0044, 0001, 1900, 2017 | |
| yyyyy | ... | |
| Год (местное время) | Y | 44, 1, 1900, 2017 |
| Yo | 44th, 1st, 1900th, 2017th | |
| YY | 44, 01, 00, 17 | |
| YYY | 044, 001, 1900, 2017 | |
| YYYY | 0044, 0001, 1900, 2017 | |
| YYYYY | ... | |
| ISO номера недель | R | -43, 0, 1, 1900, 2017 |
| RR | -43, 00, 01, 1900, 2017 | |
| RRR | -043, 000, 001, 1900, 2017 | |
| RRRR | -0043, 0000, 0001, 1900, 2017 | |
| RRRRR | ... | |
| Расширенный год | u | -43, 0, 1, 1900, 2017 |
| uu | -43, 01, 1900, 2017 | |
| uuu | -043, 001, 1900, 2017 | |
| uuuu | -0043, 0001, 1900, 2017 | |
| uuuuu | ... | |
| Квартал | Q | 1, 2, 3, 4 |
| Qo | 1st, 2nd, 3rd, 4th | |
| 01, 02, 03, 04 | ||
| QQQ | Q1, Q2, Q3, Q4 | |
| QQQQ | 1st quarter, 2nd quarter, ... | |
| QQQQQ | 1, 2, 3, 4 | |
| Квартал (местное время) | q | 1, 2, 3, 4 |
| qo | 1st, 2nd, 3rd, 4th | |
| 01, 02, 03, 04 | ||
| qqq | Q1, Q2, Q3, Q4 | |
| qqqq | 1st quarter, 2nd quarter, ... | |
| qqqqq | 1, 2, 3, 4 | |
| Месяц | M | 1, 2, ..., 12 |
| Mo | 1st, 2nd, ..., 12th | |
| MM | 01, 02, ..., 12 | |
| MMM | Jan, Feb, ..., Dec | |
| MMMM | January, February, ..., December | |
| MMMMM | J, F, ..., D | |
| Месяц (местное время) | L | 1, 2, ..., 12 |
| Lo | 1st, 2nd, ..., 12th | |
| LL | 01, 02, ..., 12 | |
| LLL | Jan, Feb, ..., Dec | |
| LLLL | January, February, ..., December | |
| LLLLL | J, F, ..., D | |
| Номер недели в году | w | 1, 2, ..., 53 |
| (местное время) | wo | 1st, 2nd, ..., 53th |
| ww | 01, 02, ..., 53 | |
| ISO номер недели | I | 1, 2, ..., 53 |
| Io | 1st, 2nd, ..., 53th | |
| II | 01, 02, ..., 53 | |
| День месяца | d | 1, 2, ..., 31 |
| do | 1st, 2nd, ..., 31st | |
| dd | 01, 02, ..., 31 | |
| День в году | D | 1, 2, ..., 365, 366 |
| Do | 1st, 2nd, ..., 365th, 366th | |
| DD | 01, 02, ..., 365, 366 | |
| DDD | 001, 002, ..., 365, 366 | |
| DDDD | ... | |
| День недели | E..EEE | Mon, Tue, Wed, ..., Sun |
| (местное время) | EEEE | Monday, Tuesday, ..., Sunday |
| EEEEE | M, T, W, T, F, S, S | |
| EEEEEE | Mo, Tu, We, Th, Fr, Sa, Su | |
| ISO день недели | i | 1, 2, 3, ..., 7 |
| io | 1st, 2nd, ..., 7th | |
| ii | 01, 02, ..., 07 | |
| iii | Mon, Tue, Wed, ..., Sun | |
| iiii | Monday, Tuesday, ..., Sunday | |
| iiiii | M, T, W, T, F, S, S | |
| iiiiii | Mo, Tu, We, Th, Fr, Sa, Su | |
| День недели | e | 2, 3, 4, ..., 1 |
| (местное время) | eo | 2nd, 3rd, ..., 1st |
| ee | 02, 03, ..., 01 | |
| eee | Mon, Tue, Wed, ..., Sun | |
| eeee | Monday, Tuesday, ..., Sunday | |
| eeeee | M, T, W, T, F, S, S | |
| eeeeee | Mo, Tu, We, Th, Fr, Sa, Su | |
| День недели | c | 2, 3, 4, ..., 1 |
| (местное время) | co | 2nd, 3rd, ..., 1st |
| cc | 02, 03, ..., 01 | |
| ccc | Mon, Tue, Wed, ..., Sun | |
| cccc | Monday, Tuesday, ..., Sunday | |
| ccccc | M, T, W, T, F, S, S | |
| cccccc | Mo, Tu, We, Th, Fr, Sa, Su | |
| AM, PM | a..aa | AM, PM |
| aaa | am, pm | |
| aaaa | a.m., p.m. | |
| aaaaa | a, p | |
| AM, PM, noon, midnight | b..bb | AM, PM, noon, midnight |
| bbb | am, pm, noon, midnight | |
| bbbb | a.m., p.m., noon, midnight | |
| bbbbb | a, p, n, mi | |
| Относительное время | B..BBB | at night, in the morning, ... |
| BBBB | at night, in the morning, ... | |
| BBBBB | at night, in the morning, ... | |
| Часы [1-12] | h | 1, 2, ..., 11, 12 |
| ho | 1st, 2nd, ..., 11th, 12th | |
| hh | 01, 02, ..., 11, 12 | |
| Часы [0-23] | H | 0, 1, 2, ..., 23 |
| Ho | 0th, 1st, 2nd, ..., 23rd | |
| HH | 00, 01, 02, ..., 23 | |
| Часы [0-11] | K | 1, 2, ..., 11, 0 |
| Ko | 1st, 2nd, ..., 11th, 0th | |
| KK | 01, 02, ..., 11, 00 | |
| Часы [1-24] | k | 24, 1, 2, ..., 23 |
| ko | 24th, 1st, 2nd, ..., 23rd | |
| kk | 24, 01, 02, ..., 23 | |
| Минуты | m | 0, 1, ..., 59 |
| mo | 0th, 1st, ..., 59th | |
| mm | 00, 01, ..., 59 | |
| Секунды | s | 0, 1, ..., 59 |
| so | 0th, 1st, ..., 59th | |
| ss | 00, 01, ..., 59 | |
| Доля секунды | S | 0, 1, ..., 9 |
| SS | 00, 01, ..., 99 | |
| SSS | 000, 001, ..., 999 | |
| SSSS | ... | |
| Часовой пояс | X | -08, +0530, Z |
| (ISO-8601 w/ Z) | XX | -0800, +0530, Z |
| XXX | -08:00, +05:30, Z | |
| XXXX | -0800, +0530, Z, +123456 | |
| XXXXX | -08:00, +05:30, Z, +12:34:56 | |
| Часовой пояс | x | -08, +0530, +00 |
| (ISO-8601 w/o Z) | xx | -0800, +0530, +0000 |
| xxx | -08:00, +05:30, +00:00 | |
| xxxx | -0800, +0530, +0000, +123456 | |
| xxxxx | -08:00, +05:30, +00:00, +12:34:56 | |
| Часовой пояс (GMT) | O...OOO | GMT-8, GMT+5:30, GMT+0 |
| OOOO | GMT-08:00, GMT+05:30, GMT+00:00 | |
| Часовой пояс | z...zzz | GMT-8, GMT+5:30, GMT+0 |
| (конкретный нелокализованный) | zzzz | GMT-08:00, GMT+05:30, GMT+00:00 |
| timestamp (секунды) | t | 512969520 |
| tt | ... | |
| timestamp (миллисекунды) | T | 512969520900 |
| TT | ... | |
| Локализованая дата | P | 03/06/2025 |
| PP | Mar 6, 2025 | |
| PPP | March 6th, 2025 | |
| PPPP | Thursday, March 6th, 2025 | |
| Локализованное время | p | 12:00 AM |
| pp | 12:00:00 AM | |
| ppp | 12:00:00 AM GMT+2 | |
| pppp | 12:00:00 AM GMT+02:00 | |
| Комбинация даты и времени | Pp | 04/29/1453, 12:00 AM |
| PPpp | Apr 29, 1453, 12:00:00 AM | |
| PPPppp | April 29th, 1453 at ... | |
| PPPPpppp | Friday, April 29th, 1453 at ... |