Re: 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