Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > pgsql.general > #3

Typo in the timezone docs?

Show all headers | View raw

In the section on Times, the documentation has this to say...

```
8.5.1.2. Times

The time-of-day types are time [ (p) ] without time zone and time [ (p) ] with time zone. time alone is equivalent to time without time zone.

Valid input for these types consists of a time of day followed by an optional time zone. (See Table 8-11 and Table 8-12.) If a time zone is specified in the input for time without time zone, it is silently ignored. You can also specify a date but it will be ignored, except when you use a time zone name that involves a daylight-savings rule, such as America/New_York. In this case specifying the date is required in order to determine whether standard or daylight-savings time applies. The appropriate time zone offset is recorded in the time with time zone value.
```

Where it says, "You can also specify a date but it will be ignored", I'd have thought it should say "You can also specify time zone in the input for date but it will be ignored".

Is my understanding correct?

Cheers,
Andy

Back to pgsql.general | Previous | Next | Find similar

Thread

Typo in the timezone docs? Andy Chambers <achambers.home@gmail.com> - 2015-11-13 15:21 -0800

csiph-web