CODEWITHSUNDEEP
postgresqldatetimerfc3339
Yuji Tabata
Yuji Tabata

Reputation: 11

Is using T to separate date and time inconsistent with RFC3339?

In the documentation for date/time type in Postgres, it says:

ISO 8601 specifies the use of uppercase letter T to separate the date and time. PostgreSQL accepts that format on input, but on output it uses a space rather than T, as shown above. This is for readability and for consistency with RFC 3339 as well as some other database systems.

However, I cannot find that part in RFC3339. Can anybody help me?

Upvotes: 1

Views: 583

Answers (1)

S-Man
S-Man

Reputation: 23756

Section 5.6

date-time       = full-date "T" full-time

      NOTE: Per [ABNF] and ISO8601, the "T" and "Z" characters in this
      syntax may alternatively be lower case "t" or "z" respectively.

      This date/time format may be used in some environments or contexts
      that distinguish between the upper- and lower-case letters 'A'-'Z'
      and 'a'-'z' (e.g. XML).  Specifications that use this format in
      such environments MAY further limit the date/time syntax so that
      the letters 'T' and 'Z' used in the date/time syntax must always
      be upper case.  Applications that generate this format SHOULD use
      upper case letters.

      NOTE: ISO 8601 defines date and time separated by "T".
      Applications using this syntax may choose, for the sake of
      readability, to specify a full-date and full-time separated by
      (say) a space character.

Upvotes: 3

Related Questions