# Format a date

{% hint style="info" %}
The following table defines the token substrings you can use in a date-time format pattern for the functions DATEPARSE(str, format) and DATEFORMAT(date, format).
{% endhint %}

You can define the `format` field by combining the tokens shown below.

## Usual format token

Examples below given for `2014-08-06T13:07:04.054` considered as a local time in America/New\_York

<table data-full-width="false"><thead><tr><th width="332">To display</th><th width="314">Use this token</th><th>Example</th></tr></thead><tbody><tr><td>year, unpadded</td><td>y</td><td><code>2014</code></td></tr><tr><td>two-digit year</td><td>yy</td><td><code>14</code></td></tr><tr><td>four- to six- digit year, pads to 4</td><td>yyyy</td><td><code>2014</code></td></tr><tr><td>month as an unpadded number</td><td>M</td><td><code>8</code></td></tr><tr><td>month as a padded number</td><td>MM</td><td><code>08</code></td></tr><tr><td>month as an abbreviated localized string</td><td>MMM</td><td><code>Aug</code></td></tr><tr><td>month as an unabbreviated localized string</td><td>MMMM</td><td><code>August</code></td></tr><tr><td>month as a single localized letter</td><td>MMMMM</td><td><code>A</code></td></tr><tr><td>day of the month, no padding</td><td>d</td><td><code>6</code></td></tr><tr><td>day of the month, padded to 2</td><td>dd</td><td><code>06</code></td></tr><tr><td>hour in 12-hour time, no padding</td><td>h</td><td><code>1</code></td></tr><tr><td>hour in 12-hour time, padded to 2</td><td>hh</td><td><code>01</code></td></tr><tr><td>hour in 24-hour time, no padding</td><td>H</td><td><code>13</code></td></tr><tr><td>hour in 24-hour time, padded to 2</td><td>HH</td><td><code>13</code></td></tr><tr><td>minute, no padding</td><td>m</td><td><code>7</code></td></tr><tr><td>minute, padded to 2</td><td>mm</td><td><code>07</code></td></tr><tr><td>second, no padding</td><td>s</td><td><code>4</code></td></tr><tr><td>second, padded to 2 padding</td><td>ss</td><td><code>04</code></td></tr><tr><td>fractional seconds, functionally identical to SSS</td><td>u</td><td><code>054</code></td></tr><tr><td>fractional seconds, between 0 and 99, padded to 2</td><td>uu</td><td><code>05</code></td></tr><tr><td>fractional seconds, between 0 and 9</td><td>uuu</td><td><code>0</code></td></tr><tr><td>millisecond, no padding</td><td>S</td><td><code>54</code></td></tr><tr><td>millisecond, padded to 3</td><td>SSS</td><td><code>054</code></td></tr></tbody></table>

## Advanced format token

Examples below given for `2014-08-06T13:07:04.054` considered as a local time in America/New\_York

<table><thead><tr><th width="276">To display</th><th width="170">Use this token</th><th>Example</th></tr></thead><tbody><tr><td>ordinal (day of year), unpadded</td><td>o</td><td><code>218</code></td></tr><tr><td>ordinal (day of year), padded to 3</td><td>ooo</td><td><code>218</code></td></tr><tr><td>quarter, no padding</td><td>q</td><td><code>3</code></td></tr><tr><td>quarter, padded to 2</td><td>qq</td><td><code>03</code></td></tr><tr><td>ISO week year, unpadded</td><td>kk</td><td><code>14</code></td></tr><tr><td>ISO week year, padded to 4</td><td>kkkk</td><td><code>2014</code></td></tr><tr><td>ISO week number, unpadded</td><td>W</td><td><code>32</code></td></tr><tr><td>ISO week number, padded to 2</td><td>WW</td><td><code>32</code></td></tr><tr><td>Local week year, unpadded</td><td>ii</td><td><code>14</code></td></tr><tr><td>Local week year, padded to 4</td><td>iiii</td><td><code>2014</code></td></tr><tr><td>Local week number, unpadded</td><td>n</td><td><code>32</code></td></tr><tr><td>Local week number, padded to 2</td><td>nn</td><td><code>32</code></td></tr><tr><td>day of the week, as number from 1-7 (Monday is 1, Sunday is 7)</td><td>E</td><td><code>3</code></td></tr><tr><td>day of the week, as an abbreviate localized string</td><td>EEE</td><td><code>Wed</code></td></tr><tr><td>day of the week, as an unabbreviated localized string</td><td>EEEE</td><td><code>Wednesday</code></td></tr><tr><td>day of the week, as a single localized letter</td><td>EEEEE</td><td><code>W</code></td></tr><tr><td>localized numeric date</td><td>D</td><td><code>9/4/2017</code></td></tr><tr><td>localized date with abbreviated month</td><td>DD</td><td><code>Aug 6, 2014</code></td></tr><tr><td>localized date with full month</td><td>DDD</td><td><code>August 6, 2014</code></td></tr><tr><td>localized date with full month and weekday</td><td>DDDD</td><td><code>Wednesday, August 6, 2014</code></td></tr><tr><td>localized time</td><td>t</td><td><code>9:07 AM</code></td></tr><tr><td>localized time with seconds</td><td>tt</td><td><code>1:07:04 PM</code></td></tr><tr><td>localized time with seconds and abbreviated offset</td><td>ttt</td><td><code>1:07:04 PM EDT</code></td></tr><tr><td>localized time with seconds and full offset</td><td>tttt</td><td><code>1:07:04 PM Eastern Daylight Time</code></td></tr><tr><td>localized 24-hour time</td><td>T</td><td><code>13:07</code></td></tr><tr><td>localized 24-hour time with seconds</td><td>TT</td><td><code>13:07:04</code></td></tr><tr><td>localized 24-hour time with seconds and abbreviated offset</td><td>TTT</td><td><code>13:07:04 EDT</code></td></tr><tr><td>localized 24-hour time with seconds and full offset</td><td>TTTT</td><td><code>13:07:04 Eastern Daylight Time</code></td></tr><tr><td>short localized date and time</td><td>f</td><td><code>8/6/2014, 1:07 PM</code></td></tr><tr><td>less short localized date and time</td><td>ff</td><td><code>Aug 6, 2014, 1:07 PM</code></td></tr><tr><td>verbose localized date and time</td><td>fff</td><td><code>August 6, 2014, 1:07 PM EDT</code></td></tr><tr><td>extra verbose localized date and time</td><td>ffff</td><td><code>Wednesday, August 6, 2014, 1:07 PM Eastern Daylight Time</code></td></tr><tr><td>short localized date and time with seconds</td><td>F</td><td><code>8/6/2014, 1:07:04 PM</code></td></tr><tr><td>less short localized date and time with seconds</td><td>FF</td><td><code>Aug 6, 2014, 1:07:04 PM</code></td></tr><tr><td>verbose localized date and time with seconds</td><td>FFF</td><td><code>August 6, 2014, 1:07:04 PM EDT</code></td></tr><tr><td>extra verbose localized date and time with seconds</td><td>FFFF</td><td><code>Wednesday, August 6, 2014, 1:07:04 PM Eastern Daylight Time</code></td></tr><tr><td>narrow offset</td><td>Z</td><td><code>+5</code></td></tr><tr><td>short offset</td><td>ZZ</td><td><code>+05:00</code></td></tr><tr><td>techie offset</td><td>ZZZ</td><td><code>+0500</code></td></tr><tr><td>abbreviated named offset</td><td>ZZZZ</td><td><code>EST</code></td></tr><tr><td>unabbreviated named offset</td><td>ZZZZZ</td><td><code>Eastern Standard Time</code></td></tr><tr><td>IANA zone</td><td>z</td><td><code>America/New_York</code></td></tr><tr><td>meridiem</td><td>a</td><td><code>AM</code></td></tr><tr><td>unix timestamp in seconds</td><td>X</td><td><code>1407287224</code></td></tr><tr><td>unix timestamp in milliseconds</td><td>x</td><td><code>1407287224054</code></td></tr></tbody></table>