On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote:
> rbt=# select cast(now() - date_trunc('day', now()) as time);
> time
> -----------------
> 13:10:42.495579
> (1 row)
Am I missing something? Is there a reason not to simply cast the
timestamp value to time?
test=> select cast(now() - date_trunc('day', now()) as time);
time
---------------------
11:19:19.8921250105
(1 row)
test=> select now()::time;
now
-----------------
11:19:19.892125
(1 row)
test=> select cast(now() as time);
now
-----------------
11:19:19.892125
(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
