Обсуждение: time representation bug

Поиск
Список
Период
Сортировка

time representation bug

От
"Vilson farias"
Дата:
bxs=#
bxs=# SELECT date_trunc('MINUTE', CAST (hora_minuto AS TIME)) AS hora_cham
bxs-# FROM hora_minuto;
 hora_cham
-----------
 00:000 <<hu??? Inside Delphi 5, it makes my life a real hell when I create
charts to show data from this table.
 00:01
 00:02
 00:03
 00:04
 00:05
 00:06
 00:07



Re: time representation bug

От
Tom Lane
Дата:
"Vilson farias" <vilson.farias@digitro.com.br> writes:
> bxs=# SELECT date_trunc('MINUTE', CAST (hora_minuto AS TIME)) AS hora_cham
> bxs-# FROM hora_minuto;
>  hora_cham
> -----------
>  00:000 <<hu???

Seems to be fixed in 7.1.

            regards, tom lane