The SQL standard states that "Within the definition of a 'datetime literal', the 'datetime values'
Table B-1 shows the tokens that are recognized as names of months. Table B-1. Month Names
Since timezone abbreviations are not well standardized, PostgreSQL provides a means to customize the set of abbreviations accepted by the server
The date/time type inputs are all decoded using the following procedure. Break the input