time representation bug

Started by Vilson fariasabout 25 years ago2 messagesgeneral

vilson.farias@digitro.com.br

about 25 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

about 25 years ago

In reply to: Vilson farias (#1)

Re: time representation bug

"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