Re: analytic question

From: CarlosAL <miotromailcarlos_at_netscape.net>
Date: Thu, 3 Mar 2011 00:56:58 -0800 (PST)
Message-ID: <b4edeeae-7784-405e-af8e-baefa75ffa4d_at_w9g2000prg.googlegroups.com>



On Mar 3, 9:15 am, yossarian <yossaria..._at_operamail.com> wrote:
> Gerard H. Pille wrote:
> >> where day>=date'2007-01-01'
>
> > Is this a valid syntax for Oracle?
>
> Undocumented but valid AFAIK.
>
>         Y.

This is ANSI SQL. Most databases will accept this form as a valid sentence.

Cheers.

Carlos. Received on Thu Mar 03 2011 - 02:56:58 CST

Original text of this message