Home > mailing lists

Question about time - Mailing list pgsql-sql

From	Judith
Subject	Question about time
Date	November 16, 2006 21:12:22
Msg-id	455C8E4F.5060406@correolux.com.mx Whole thread Raw
Responses	Re: Question about time Re: Question about time
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Andrew Sullivan
Date: 16 November 2006, 20:20:54
Subject: Re: Random()

From: "Phillip Smith"
Date: 16 November 2006, 21:28:14
Subject: Re: Question about time

Question about time - Mailing list pgsql-sql

Previous

Next