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