[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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
