Re: time

[Please copy the mailing list on replies.]

On Thu, Nov 10, 2005 at 12:24:17PM -0600, Judith Altamirano Figueroa wrote:
> excuse me and how can I just get the hour, minute and second

The time type takes an optional precision:

test=> select now()::time;      now       
-----------------11:36:34.124678
(1 row)

test=> select now()::time(0);  now    
----------11:36:34
(1 row)

test=> select now()::time(2);    now     
-------------11:36:34.12
(1 row)

-- 
Michael Fuhr