Re: analytic question
From: joel garry <joel-garry_at_home.com>
Date: Wed, 2 Mar 2011 09:33:57 -0800 (PST)
Message-ID: <b43e50a3-b83b-4e8b-a5b7-8267428eda0c_at_o30g2000pra.googlegroups.com>
On Mar 2, 9:03 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> yossarian wrote:
> > where day>=date'2007-01-01'
>
> Is this a valid syntax for Oracle?
01-01-2007
Date: Wed, 2 Mar 2011 09:33:57 -0800 (PST)
Message-ID: <b43e50a3-b83b-4e8b-a5b7-8267428eda0c_at_o30g2000pra.googlegroups.com>
On Mar 2, 9:03 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> yossarian wrote:
> > where day>=date'2007-01-01'
>
> Is this a valid syntax for Oracle?
TTST> alter session set nls_date_format="MM-DD-YYYY";
Session altered.
TTST> select date'2007-01-01' from dual;
DATE'2007-
01-01-2007
Learn something new every day. Though this one sounds kind of familiar.
jg
-- _at_home.com is bogus. Indian musical chairs: http://www.thehindubusinessline.com/industry-and-economy/info-tech/article1503683.eceReceived on Wed Mar 02 2011 - 11:33:57 CST