| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | Judith Altamirano Figueroa <jaltamirano(at)correolux(dot)com(dot)mx>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: time |
| Date: | 2005-11-10 18:27:10 |
| Message-ID: | 1131647230.819.147.camel@home |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-11-10 18:38:12 | Re: time |
| Previous Message | Michael Fuhr | 2005-11-10 18:21:39 | Re: time |