BUG #7886: date_trunc(date) returning timestamptz instead of timestamp

Поиск
Список
Период
Сортировка
От nick.baxter@gmail.com
Тема BUG #7886: date_trunc(date) returning timestamptz instead of timestamp
Дата
Msg-id E1U6Som-0004Pz-RQ@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7886: date_trunc(date) returning timestamptz instead of timestamp  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7886
Logged by:          Nick Baxter
Email address:      nick.baxter@gmail.com
PostgreSQL version: 9.0.3
Operating system:   Linux 2.6.18
Description:        =


9.9.2. indicates that date_trunc can be called with a date value (which will
be cast to a timestamp). And regardless of the input, that the result will
be of type timestamp. When I call it with a date, I get a timestamp with
time zone instead, as indicated by the psql output.

# select date_trunc('month',date '2013-2-15');
       date_trunc
------------------------
 2013-02-01 00:00:00-06
(1 row)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #7885: postmaster panic on startup does not release shared memory
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #7886: date_trunc(date) returning timestamptz instead of timestamp