From: | "Hector Villarreal" <HVillarreal(at)mynewplace(dot)com> |
---|---|
To: | "Joe" <dev(at)freedomcircle(dot)net>, "Judith" <jaltamirano(at)correolux(dot)com(dot)mx> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Question about time |
Date: | 2006-11-16 23:19:17 |
Message-ID: | 8C5B026B51B6854CBE88121DBF097A865D4530@ehost010-33.exch010.intermedia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Try this one:
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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Joe
Sent: Thursday, November 16, 2006 2:24 PM
To: Judith
Cc: pgsql-sql(at)postgresql(dot)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:
>
> SELECT CAST(fecha_hora_factura as time) FROM nota_venta
>
> and I get:
>
> 14:16:52.824395
>
> the field is timestamp type....... I just want the
HOUR:MINUTE:SECOND
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-11-17 03:54:23 | Re: [pgadmin-support] Groups and Roles and Users |
Previous Message | Phillip Smith | 2006-11-16 22:27:58 | Re: Question about time |