| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Rod Taylor <pg(at)rbt(dot)ca>, Judith Altamirano Figueroa <jaltamirano(at)correolux(dot)com(dot)mx>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: time |
| Date: | 2005-11-10 19:22:39 |
| Message-ID: | 20051110192239.GA60396@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Nov 10, 2005 at 02:13:43PM -0500, Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > Am I missing something? Is there a reason not to simply cast the
> > timestamp value to time?
>
> I think the OP was trying to use the functional cast syntax
> time(now())
> which worked long ago, but has not since we added the
> SQL-spec time precision syntax.
I was referring to the expression that Rod Taylor posted, wondering
if there was some subtlety I was missing or if Rod simply didn't
think of the simpler solution (Rod responded indicating the latter).
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tadej Kanizar | 2005-11-10 19:29:07 | Re: time |
| Previous Message | Tom Lane | 2005-11-10 19:13:43 | Re: time |