current date/time precision

From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: current date/time precision
Date: 2003-06-11 13:07:45
Message-ID: 01f301c3301a$78e6cb20$0701a8c0@netterm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Which are the parameter for set the precision of the current_time function

like:

i get from ´SELECT CURRENT_TIME;´

10:14:19.455777-03

but I just want hours and minutes.

tnx

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO

Browse pgsql-general by date

  From Date Subject
Next Message Bob Powell 2003-06-11 13:11:37 Multilple email being delivered
Previous Message Karsten Hilbert 2003-06-11 12:59:53 doing VALID UNTIL programmatically in SQL ?