PostgreSQL 9.4
PostgreSQL 9.4
  • 请登录查看
字典 我要纠错

Date/Time Input Interpretation

B.1. Date/Time Input Interpretation

The date/time type inputs are all decoded using the following procedure.

  1. Break the input string into tokens and categorize each token as a string, time, time zone, or number.

    1. If the numeric token contains a colon (:), this is a time string. Include all subsequent digits and colons.

    2. If the numeric token contains a dash (-), slash (/), or two or more dots (.), this is a date string which might have a text month. If a date token has already been seen, it is instead interpreted as a time zone name (e.g., America/New_York).

    3. If the token is numeric only, then it is either a single fiel