Question about time

From: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question about time
Date: 2006-11-16 16:14:07
Message-ID: 455C8E4F.5060406@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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??

Thnx in advanced!!!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-11-16 18:31:14 Random()
Previous Message T E Schmitz 2006-11-16 15:36:03 Re: psql -F <TAB>