Postgres Date/Time Format Token Coverage — Legend SQL

Reference: PostgreSQL 16 Data Type Formatting Functions (Table 9.25) and Date/Time Functions (Table 9.33).

to_char tokens (54/58 TDS PASS, 54/58 Relation PASS)

Token TDS Relation Test(s)
HH PASS PASS to_char_token__HH
HH12 PASS PASS to_char_token__HH12
HH24 PASS PASS to_char_token__HH24
MI PASS PASS to_char_token__MI
SS PASS PASS to_char_token__SS
MS PASS PASS to_char_token__MS
US PASS PASS to_char_token__US
FF1 FAIL FAIL to_char_token__FF1
FF6 FAIL FAIL to_char_token__FF6
SSSS PASS PASS to_char_token__SSSS
AM PASS PASS to_char_token__AM
PM PASS PASS to_char_token__PM
Y,YYY PASS PASS to_char_token__Y_YYY
YYYY PASS PASS to_char_token__YYYY
YYY PASS PASS to_char_token__YYY
YY PASS PASS to_char_token__YY
Y PASS PASS to_char_token__Y
IYYY PASS PASS to_char_token__IYYY
IY PASS PASS to_char_token__IY
I PASS PASS to_char_token__I
BC PASS PASS to_char_token__BC
AD PASS PASS to_char_token__AD
MONTH PASS PASS to_char_token__MONTH
Month PASS PASS to_char_token__Month
month PASS PASS to_char_token__month
MON PASS PASS to_char_token__MON
Mon PASS PASS to_char_token__Mon
mon PASS PASS to_char_token__mon
MM PASS PASS to_char_token__MM
DAY PASS PASS to_char_token__DAY
Day PASS PASS to_char_token__Day
day PASS PASS to_char_token__day
DY PASS PASS to_char_token__DY
Dy PASS PASS to_char_token__Dy
dy PASS PASS to_char_token__dy
DDD PASS PASS to_char_token__DDD
IDDD PASS PASS to_char_token__IDDD
DD PASS PASS to_char_token__DD
D PASS PASS to_char_token__D
ID PASS PASS to_char_token__ID
W PASS PASS to_char_token__W
WW PASS PASS to_char_token__WW
IW PASS PASS to_char_token__IW
CC PASS PASS to_char_token__CC
J PASS PASS to_char_token__J
Q PASS PASS to_char_token__Q
RM PASS PASS to_char_token__RM
rm PASS PASS to_char_token__rm
TZ PASS PASS to_char_token__TZ
tz PASS PASS to_char_token__tz
TZH FAIL FAIL to_char_token__TZH
TZM FAIL FAIL to_char_token__TZM
OF PASS PASS to_char_token__OF
FM PASS PASS to_char_token__FM_modifier
TH PASS PASS to_char_token__TH_modifier
th PASS PASS to_char_token__th_modifier
FX PASS PASS to_char_token__FX_modifier
SP PASS PASS to_char_token__SP_modifier

extract tokens (22/22 TDS PASS, 22/22 Relation PASS)

Token TDS Relation Test(s)
century PASS PASS extract_field__century
day PASS PASS extract_field__day
decade PASS PASS extract_field__decade
dow PASS PASS extract_field__dow
doy PASS PASS extract_field__doy
epoch PASS PASS extract_field__epoch
hour PASS PASS extract_field__hour
isodow PASS PASS extract_field__isodow
isoyear PASS PASS extract_field__isoyear
julian PASS PASS extract_field__julian
microseconds PASS PASS extract_field__microseconds
millennium PASS PASS extract_field__millennium
milliseconds PASS PASS extract_field__milliseconds
minute PASS PASS extract_field__minute
month PASS PASS extract_field__month
quarter PASS PASS extract_field__quarter
second PASS PASS extract_field__second
timezone PASS PASS extract_field__timezone
timezone_hour PASS PASS extract_field__timezone_hour
timezone_minute PASS PASS extract_field__timezone_minute
week PASS PASS extract_field__week
year PASS PASS extract_field__year