Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table plus
highlightColor#ffffec
rowStylesbackground:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
stylebackground-color:white;



TokenOutput
MonthM1 2 ... 11 12

Mo1st 2nd ... 11th 12th

MM01 02 ... 11 12

MMMJan Feb ... Nov Dec

MMMMJanuary February ... November December
QuarterQ1 2 3 4
Day of MonthD1 2 ... 30 31

Do1st 2nd ... 30th 31st

DD01 02 ... 30 31
Day of YearDDD1 2 ... 364 365

DDDo1st 2nd ... 364th 365th

DDDD001 002 ... 364 365
Day of Weekd0 1 ... 5 6

do0th 1st ... 5th 6th

ddSu Mo ... Fr Sa

dddSun Mon ... Fri Sat

ddddSunday Monday ... Friday Saturday
Day of Week (Locale)e0 1 ... 5 6
Day of Week (ISO)E1 2 ... 6 7
Week of Yearw1 2 ... 52 53

wo1st 2nd ... 52nd 53rd

ww01 02 ... 52 53
Week of Year (ISO)W1 2 ... 52 53

Wo1st 2nd ... 52nd 53rd

WW01 02 ... 52 53
YearYY70 71 ... 29 30

YYYY1970 1971 ... 2029 2030
Week Yeargg70 71 ... 29 30

gggg1970 1971 ... 2029 2030
Week Year (ISO)GG70 71 ... 29 30

GGGG1970 1971 ... 2029 2030
AM/PMAAM PM

aam pm
HourH0 1 ... 22 23

HH00 01 ... 22 23

h1 2 ... 11 12

hh01 02 ... 11 12
Minutem0 1 ... 58 59

mm00 01 ... 58 59
Seconds0 1 ... 58 59

ss00 01 ... 58 59
Fractional SecondS0 1 ... 8 9

SS0 1 ... 98 99

SSS0 1 ... 998 999
Timezonez or zzEST CST ... MST PST 
Note: as of 1.6.0, the z/zz format tokens have been deprecated. Read more about it here.

Z-07:00 -06:00 ... +06:00 +07:00

ZZ-0700 -0600 ... +0600 +0700
Unix TimestampX1360013296


Examples

M~YYYY.MM.DD

Column type

Input format

Display format

<default>

YYYY.MM.DDMDDMMMYYYY~YYYY.MM.DD

DDMMMYYYY

YYYY.MM.DD

M(de)DDMMMYYYY~YYYY.MM.DD(de)DDMMMYYYY

YYYY.MM.DD

MX~DD.MM.YYUnix timestampDD.MM.YYMDD MMM YYYY~YYYY.MM.DD

DD MMM YYYY

Default Confluence Date Picker (US)

YYYY.MM.DD

...