Re: How to join two tables while one is using Date and another is using Timestamp?

From: Mladen Gogala <>
Date: 13 Jun 2008 07:10:32 GMT
Message-ID: <48521d68$0$30637$>

On Thu, 12 Jun 2008 16:20:16 -0400, Walt wrote: ry will be dog slow with these
> functions.
> Have you tried letting the implicit conversion do it's magic? It
> *should* simply snip off fractional seconds when converting timestamp to
> a date, but I haven't tried this.

Also, with the advent of functional indexes, joining over to_char shouldn't be such a problem.

Mladen Gogala
Received on Fri Jun 13 2008 - 02:10:32 CDT

Original text of this message