Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!195.96.0.7.MISMATCH!newsfeed.utanet.at!newsfeed01.chello.at!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!news1.as3257.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
Date: Thu, 03 Mar 2011 09:15:38 +0100
From: yossarian <yossarian99@operamail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.12) Gecko/20070301 SUSE/1.8_seamonkey_1.0.9-1.15 SeaMonkey/1.0.9
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: analytic question
References: <4d6e681f$0$30910$5fc30a8@news.tiscali.it> <4d6e784f$0$14246$ba620e4c@news.skynet.be>
In-Reply-To: <4d6e784f$0$14246$ba620e4c@news.skynet.be>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Lines: 9
Message-ID: <4d6f4e2b$0$6820$5fc30a8@news.tiscali.it>
Organization: Tiscali SpA
NNTP-Posting-Host: 82.85.0.130
X-Trace: 1299140139 news.tiscali.it 6820 82.85.0.130:32967
X-Complaints-To: abuse@tiscali.it
Xref:  news.cambrium.nl

Gerard H. Pille wrote:

>> where day>=date'2007-01-01'
> 
> Is this a valid syntax for Oracle?

Undocumented but valid AFAIK.

	Y.