PhixFlow Help

Date and Time Format Patterns

The following values are available for use in date format patterns:

Symbol
Meaning
Presentation
Examples
GeratextAD
Ccentury of era (>=0)number20
Yyear of era (>=0)year1996
YYyear of era (>=0)year96
YYYYyear of era (>=0)year1996
xweekyearyear1996
wweek of weekyearnumber27
eday of week (1~7, where Monday is 1)number2
Eday of weektextTue
EEEEday of weektextTuesday
yyearyear1996
yyyearyear96
yyyyyearyear1996
Dday of yearnumber189
Mmonth of yearmonth7
MMmonth of yearmonth07
MMMmonth of yearmonthJUL
MMMMmonth of yearmonthJULY
dday of monthnumber5
ddday of monthnumber05
ahalfday of daytextPM
Khour of halfday (0~11)number3
KKhour of halfday (0~11)number03
hclockhour of halfday (1~12)number5
hhclockhour of halfday (1~12)number05
Hhour of day (0~23)number6
HHhour of day (0~23)number06
kclockhour of day (1~24)number9
kkclockhour of day (1~24)number09
mminute of hournumber5
mmminute of hournumber05
ssecond of minutenumber7
sssecond of minutenumber07
Sfraction of secondnumber978
'escape for textdelimiter
''single quoteliteral'
The following formats are not available in Date Time Formats:
Ztime zone offset/idzone-0800
ZZtime zone offset/idzone-08:00
ZZZtime zone offset/idzoneAmerica/Los_Angeles

The following format is not available for use in toString, which will instead return the same as Z. 

The time zones supported will be dependent on your server settings. Unsupported time zones will result in an error during analysis.

ztime zonetext

PST

The number of letters used in the pattern determines the format.

  • Text: If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available.
  • Number: The minimum number of digits. Shorter numbers are zero-padded to this amount.
  • Year: Numeric presentation for year and weekyear fields are handled specially. For example, if the count of 'y' is 2, the year will be displayed as the zero-based year of the century, which is two digits.
  • Month: 3 or over, use text, otherwise use number.
  • Zone: 'Z' outputs offset without a colon, 'ZZ' outputs the offset with a colon, 'ZZZ' or more outputs the zone id.
  • Any characters in the pattern that are not in the ranges of ['a'..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', '.', ' ', '#' and '?' will appear in the resulting time text even they are not embraced within single quotes.

Please let us know if we could improve this page feedback@phixflow.com