timestamp field - select error

Поиск
Список
Период
Сортировка
От alexandre :: aldeia digital
Тема timestamp field - select error
Дата
Msg-id 1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br
обсуждение исходный текст
Ответы Re: timestamp field - select error
Список pgsql-sql
Hi,

I have a large table with a timestamp field.

select cf03dthr from cf03t where cf03dthr <= '2003-12-31'::timestamp ORDER
BY cf03dthr DESC LIMIT 3
     cf03dthr
---------------------2003-05-27 01:01:012003-05-26 09:50:552003-05-26 09:49:54
(3 rows)

(...) where cf03dthr <= '2003-05-27' (...)
     cf03dthr
---------------------2003-05-26 09:52:282003-05-26 09:50:552003-05-26 09:49:54
(3 rows)

* But if I do: (...) where cf03dthr <= '2003-05-26' (...)
* I get: "ERROR:  convert_timevalue_to_scalar: unsupported type 16976"
* This occurs in any other dates...

If I do: (...) where cf03dthr <= '2003-05-26 09:00:00' (...), for example,
the rows returns OK, but <= '2003-05-26 06:00:00' or many other
combinations give me the same error.


Thank´s for any help.

alexandre





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

Предыдущее
От: Mukta Telang
Дата:
Сообщение: Many-to-Many relation
Следующее
От: "Michael Mattox"
Дата:
Сообщение: How to delete multiple rows from multiple joined tables