time representation bug

From: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: time representation bug
Date: 2001-03-22 21:04:03
Message-ID: 006f01c0b313$a018bc20$98a0a8c0@dti.digitro.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard H 2001-03-22 21:15:47 Re: JOIN
Previous Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2001-03-22 21:02:11 Re: Call for platforms