Re: How to join two tables while one is using Date and another is using Timestamp?
Date: 13 Jun 2008 07:10:32 GMT
On Thu, 12 Jun 2008 16:20:16 -0400, Walt wrote: ry will be dog slow with these
> 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 http://mgogala.freehostia.comReceived on Fri Jun 13 2008 - 02:10:32 CDT