On Thu, 2005-11-10 at 11:21 -0700, Michael Fuhr wrote:
> 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?
Nope. I had thought that the question came up because a straight cast
didn't work so I gave the first work around I thought of.
--