Re: BETWEEN not matching on timestamp value

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BETWEEN not matching on timestamp value
Дата
Msg-id 23081.1246385260@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BETWEEN not matching on timestamp value  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Список pgsql-general
"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> The column is a timestamp value.  I expected any time on any given
> date to fall between the start and end of that day so the
> hh:mm:ss:hh portion does not leap out at me as something that should
> cause a problem.  Should  it?

It's the eight-digit year field that it's unhappy with ...

            regards, tom lane

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: BETWEEN not matching on timestamp value
Следующее
От: "James B. Byrne"
Дата:
Сообщение: Re: BETWEEN not matching on timestamp value]