Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Question about time
Date: Thu, 16 Nov 2006 15:19:17 -0800
Message-ID: 
 <8C5B026B51B6854CBE88121DBF097A865D4530@ehost010-33.exch010.intermedia.net>
In-Reply-To: <1163715824.692.1.camel@pampa>
Thread-Topic: [SQL] Question about time
Thread-Index: AccJzlfXSqATKw/aRN6wEqqFbBCwiQABxxyw
From: "Hector Villarreal" <HVillarreal@mynewplace.com>
To: "Joe" <dev@freedomcircle.net>,
	"Judith" <jaltamirano@correolux.com.mx>
Cc: <pgsql-sql@postgresql.org>

Try this one:=20

SELECT date_trunc('seconds',now())::time;
"15:11:42"

So it should be select date_trunc('seconds', fecha_hora_factura)::time
from nota_venta;

-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Joe
Sent: Thursday, November 16, 2006 2:24 PM
To: Judith
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Question about time

On Thu, 2006-11-16 at 10:14 -0600, Judith wrote:
>     Hi everyone I'm doing a query like this:
>=20
>     SELECT CAST(fecha_hora_factura as time) FROM nota_venta
>=20
>     and I get:
>=20
>     14:16:52.824395
>=20
>     the field is timestamp type....... I just want the
HOUR:MINUTE:SECOND
>=20
>     the question is how I drop the millisecond??

Take a look at date_trunc() under Date/Time Functions and Operators.

Joe


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate