Re: problem with a column of type timestamp

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: problem with a column of type timestamp
Дата
Msg-id 2F8EE15B-ADA8-4E65-A986-65D03D2425B0@seespotcode.net
обсуждение исходный текст
Ответ на problem with a column of type timestamp  (Sascha Bohnenkamp <bohnenkamp@mevisbreastcare.de>)
Список pgsql-general
On Oct 16, 2007, at 1:55 , Sascha Bohnenkamp wrote:

> PGRES_FATAL_ERROR
> column "birthtime" is of type timestamp without time zone but
> expression
> is of type time without time zone  You will need to rewrite or cast
> the
> expression.
>
> how can I set the timezone?

The issue isn't the time zone: I believe it's that one is a
*timestamp* while the other is a *time*;

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: brian
Дата:
Сообщение: Re: problem with a column of type timestamp
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.3 beta problems