---
title: "Formatting options for date columns - Cloud"
canonical: "https://support.appfire.com/space/SQL/74324904/Formatting%20options%20for%20date%20columns%20-%20Cloud"
format: markdown
---
> Macro (aura-html)

# <span style="color: #000000">Overview</span>

<span style="color: #000000">It is possible to specify the format that is used to view date columns. Note that the actual data is not changed, just how it is displayed varies. This helps keep the data looking consistent even if the provided data is not. This can be enabled by using the </span><span style="color: #000000">*Date *</span><span style="color: #000000">column type for the</span> *Column types* <span style="color: #000000">parameter corresponding to the column. </span>[Advanced date sorting](https://bobswift.atlassian.net/wiki/x/TQESjQ) <span style="color: #000000">specifies how to use the </span><span style="color: #000000">*Date *</span><span style="color: #000000">column type to customize the column data interpretation as a date.</span>

<span style="color: #000000">Two date formats are needed to support both interpreting the data and formatting the output. </span>

- <u><span style="color: #000000">Input format</span></u><span style="color: #000000"> - this is the first format specified on the </span><span style="color: #000000">*Date *</span><span style="color: #000000">column type, although it is defaulted when nothing is specified. See</span> [Advanced date sorting](https://bobswift.atlassian.net/wiki/x/TQESjQ)<span style="color: #000000"> for more details.</span>
- <u><span style="color: #000000">Display format</span></u><span style="color: #000000"> - this is how you want the date to be displayed and sorted. If it is not specified, the column is displayed as-is. The display format is similar but a bit more complex than the input format. It is summarized in the succeeding sections. The </span><span style="color: #000000">**~**</span><span style="color: #000000"> character is used to separated the input and display formats to avoid most conflicts with characters used in formats.</span>

# <span style="color: #000000">Formatting options</span>

> ℹ️ ### Acknowledgement
> ℹ️ 
> ℹ️ <span style="color: #000000">Advanced date sorting support with the </span><span style="color: #000000">*Date *</span><span style="color: #000000">column type is provided using JavaScript implemented </span><span style="color: #000000">with the h</span><span style="color: #000000">elp of the</span> [Moment.js](http://momentjs.com/) <span style="color: #000000">library (open source, MIT license). A summary of the relevant parts of the</span> <span style="color: #000000">Moment.js documentation</span> <span style="color: #000000">is repeated here.</span>

> Macro (table-plus)
> 
> |  | Token | Output |
> | --- | --- | --- |
> | **Month** | M | 1 2 ... 11 12 |
> |  | Mo | 1st 2nd ... 11th 12th |
> |  | MM | 01 02 ... 11 12 |
> |  | MMM | Jan Feb ... Nov Dec |
> |  | MMMM | January February ... November December |
> | Quarter | Q | 1 2 3 4 |
> | **Day of Month** | D | 1 2 ... 30 31 |
> |  | Do | 1st 2nd ... 30th 31st |
> |  | DD | 01 02 ... 30 31 |
> | **Day of Year** | DDD | 1 2 ... 364 365 |
> |  | DDDo | 1st 2nd ... 364th 365th |
> |  | DDDD | 001 002 ... 364 365 |
> | **Day of Week** | d | 0 1 ... 5 6 |
> |  | do | 0th 1st ... 5th 6th |
> |  | dd | Su Mo ... Fr Sa |
> |  | ddd | Sun Mon ... Fri Sat |
> |  | dddd | Sunday Monday ... Friday Saturday |
> | **Day of Week (Locale)** | e | 0 1 ... 5 6 |
> | **Day of Week (ISO)** | E | 1 2 ... 6 7 |
> | **Week of Year** | w | 1 2 ... 52 53 |
> |  | wo | 1st 2nd ... 52nd 53rd |
> |  | ww | 01 02 ... 52 53 |
> | **Week of Year (ISO)** | W | 1 2 ... 52 53 |
> |  | Wo | 1st 2nd ... 52nd 53rd |
> |  | WW | 01 02 ... 52 53 |
> | **Year** | YY | 70 71 ... 29 30 |
> |  | YYYY | 1970 1971 ... 2029 2030 |
> | **Week Year** | gg | 70 71 ... 29 30 |
> |  | gggg | 1970 1971 ... 2029 2030 |
> | **Week Year (ISO)** | GG | 70 71 ... 29 30 |
> |  | GGGG | 1970 1971 ... 2029 2030 |
> | **AM/PM** | A | AM PM |
> |  | a | am pm |
> | **Hour** | H | 0 1 ... 22 23 |
> |  | HH | 00 01 ... 22 23 |
> |  | h | 1 2 ... 11 12 |
> |  | hh | 01 02 ... 11 12 |
> | **Minute** | m | 0 1 ... 58 59 |
> |  | mm | 00 01 ... 58 59 |
> | **Second** | s | 0 1 ... 58 59 |
> |  | ss | 00 01 ... 58 59 |
> | **Fractional Second** | S | 0 1 ... 8 9 |
> |  | SS | 0 1 ... 98 99 |
> |  | SSS | 0 1 ... 998 999 |
> | **Timezone** | z or zz | EST CST ... MST PST   
> **Note:** as of **1.6.0**, the z/zz format tokens have been deprecated. [Read more about it here.](https://github.com/moment/moment/issues/162) |
> |  | Z | -07:00 -06:00 ... +06:00 +07:00 |
> |  | ZZ | -0700 -0600 ... +0600 +0700 |
> | **Unix Timestamp** | X | 1360013296 |

## <span style="color: #000000">Examples</span>

| Input format | Display format |
| --- | --- |
| <default> | YYYY.MM.DD |
| DDMMMYYYY | YYYY.MM.DD |
| (de)DDMMMYYYY | YYYY.MM.DD |
| Unix timestamp | DD.MM.YY |
| DD MMM YYYY<br>Default Confluence Date Picker (US) | YYYY.MM.DD |

## <span style="color: #000000">Internationalization</span>

<span style="color: #000000">See</span> [language support (i18n)](https://bobswift.atlassian.net/wiki/display/TBL/Advanced+Date+Sorting#AdvancedDateSorting-Languagesupport(i18n))<span style="color: #000000">.</span>