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

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 13 Jun 2008 07:10:32 GMT
Message-ID: <48521d68$0$30637$834e42db@reader.greatnowhere.com>

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
http://mgogala.freehostia.com

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

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Any one have Cisco VPN Client for Vista"
Previous message: Superboer: "statistics."
In reply to: Walt: "Re: How to join two tables while one is using Date and another is using Timestamp?"
Next in thread: Walt: "Re: How to join two tables while one is using Date and another is using Timestamp?"
Reply: Walt: "Re: How to join two tables while one is using Date and another is using Timestamp?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message