# Date-time formatting
In Quadratic you can use either preset date-time options or use custom date-time options.
## Date-time presets
Date-time presets include the standard formats you'd expect for both date and time.
## Custom formatting
A very wide range of custom formatting is supported in Quadratic. The table below reflects all available options for custom formatting.
| Spec | Example | Description |
| -------- | -------------------------------- | ------------------------------------------------------------------------------------------------------------------------ |
| %Y | 2001 | Gregorian year padded to 4 digits. Support from -262144 to 262143. |
| %C | 20 | Gregorian year divided by 100, zero-padded to 2 digits. |
| %y | 01 | Gregorian year modulo 100, zero-padded to 2 digits. |
| %m | 07 | Month number (01-12), zero-padded to 2 digits. |
| %b | Jul | Abbreviated month name. Always 3 letters. |
| %B | July | Full month name. |
| %h | Jul | Same as %b |
| %d | 08 | Day number 01-31, zero padded to 2 digits. |
| %e | 8 | Same as %d but padded. |
| %a | Sun | Abbreviated weekday name. |
| %A | Sunday | Full weekday name. |
| %w | 0 | Sunday = 0, Monday = 1, etc. |
| %u | 7 | Monday = 1, Tuesday = 2, etc. |
| %U | 28 | Week number 00-53, zero padded to 2 digits. Week starting with Sunday. |
| %W | 27 | Same as %U, but week 1 starts with Monday instead of Sunday. |
| %G | 2001 | Same as %Y but ISO 8601 year number. |
| %g | 01 | Same %y but year number in ISO 8601 |
| %V | 27 | Same as %U but uses the week number in ISO 8601 week date (01-53). |
| %j | 189 | Day of the year 001-366, zero padded to 3 digits. |
| %D | 07/08/01 | Month/day/year format. Same as %m/%d/%y. |
| %x | 07/08/01 | Same as %D except locale date representation. |
| %F | 2001-07-08 | Year-month-day format in ISO 8601. Same as %Y-%m-%d. |
| %v | 8-Jul-2001 | Day-month-year, same as %e-%b-%Y. |
| %H | 00 | Hour number 00-23, zero padded to 2 digits. |
| %k | 0 | Same as %H but space padded. Same as %\_H. |
| %I (aye) | 12 | Hour number in 12 hour clocks 01-12, zero-padded to 2 digits. |
| %l (el) | 12 | Same as %I (aye), but space-padded, same as %\_I (aye). |
| %P | am | am or pm in 12-hour clock |
| %p | AM | AM or PM in 12-hour clocks |
| %M | 34 | Minute number 00-59, zero padded to 2 digits. |
| %S | 60 | Second number 00-60, zero-padded to 2 digits. |
| %f | 26490000 | Number of nanoseconds since last whole second. |
| %.f | .026490 | Decimal fraction of a second. |
| %.3f | .026 | Decimal fraction of a second with a fixed length of 3. |
| %.6f | .026490 | Decimal fraction of a second with a fixed length of 6. |
| %.9f | .026490000 | Decimal fraction of a second with a fixed length of 9. |
| %3f | 026 | Decimal fraction of a second like `%.3f` but without the leading dot. |
| %6f | 026490 | Decimal fraction of a second like `%.6f` but without the leading dot. |
| %9f | 026490000 | Decimal fraction of a second like `%.9f` but without the leading dot. |
| %R | 00:34 | Hour-minute format. Same as `%H:%M`. |
| %T | 00:34:60 | Hour-minute-second format. Same as `%H:%M:%S`. |
| %X | 00:34:60 | Locale’s time representation (e.g., 23:13:48). |
| %r | 12:34:60 AM | Locale’s 12 hour clock time. (e.g., 11:11:04 PM). Falls back to `%X` if the locale does not have a 12 hour clock format. |
| %Z | ACST | Local time zone name. Skips all non-whitespace characters during parsing. Identical to `%:z` when formatting. |
| %z | +0930 | Offset from the local time to UTC (with UTC being `+0000`). |
| %:z | +09:30 | Same as `%z` but with a colon. |
| %::z | +09:30:00 | Offset from the local time to UTC with seconds. |
| %:::z | +09 | Offset from the local time to UTC without minutes. |
| %#z | +09 | *Parsing only:* Same as `%z` but allows minutes to be missing or present. |
| %c | Sun Jul 8 00:34:60 2001 | Locale’s date and time (e.g., Thu Mar 3 23:05:25 2005). |
| %+ | 2001-07-08T00:34:60.026490+09:30 | ISO 8601 / RFC 3339 date & time format. |
| %s | 994518299 | UNIX timestamp, the number of seconds since 1970-01-01 00:00 UTC. |
| %t | | Literal tab (\t). |
| %n | | Literal newline (\n). |
| %% | | Literal percent sign. |
| %-? | | Suppresses any padding including spaces and zeroes. (e.g. `%j` = `012`, `%-j` = `12`) |
| %\_? | | Uses spaces as a padding. (e.g. %j = 012, %\_j = 12) |
| %0? | | Uses zeroes as a padding. (e.g. %e = 9, %0e = 09) |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.quadratichq.com/spreadsheet/date-time-formatting.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.