Re: Converting MS Access SQL Query With INNER JOIN To Oracle SQL
From: <galen_boyer_at_yahoo.com>
Date: Fri, 10 Sep 2010 15:45:13 -0400
Message-ID: <14q62yd1iye.fsf_at_yahoo.com>
joel garry <joel-garry_at_home.com> writes:
Date: Fri, 10 Sep 2010 15:45:13 -0400
Message-ID: <14q62yd1iye.fsf_at_yahoo.com>
joel garry <joel-garry_at_home.com> writes:
> On Sep 10, 8:17 am, "takv..._at_gmail.com" <takv..._at_gmail.com> wrote:
>> http://www.progneer.com/wp/information_more_public.aspx?search_fd0=13...
>
>> "Moreover, in MS Access using dates is very simple and straight-forward, all you have to do is to surround the date by # (hash symbol) but in Oracle SQL to use the date in the WHERE clause you have to use the TO_DATE function."
>
> WTF??? No, I don't.
>
> select count(*) from sales_order_headers where order_date > '01-
> jan-2010';
>
> COUNT(*)
> ----------
> 3740
I hate that you can do that. I hate that Oracle allows implicit conversions!!!
-- Galen Boyer --- news://freenews.netfront.net/ - complaints: news_at_netfront.net ---Received on Fri Sep 10 2010 - 14:45:13 CDT