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?

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.ece
Received on Wed Mar 02 2011 - 11:33:57 CST

Original text of this message