Thread: time representation bug

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

"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