Re: Just as a learning exercise

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 5 May 2011 08:04:37 -0700
Message-ID: <BANLkTin6ppoNK7z4ze2D9Pp2Sc_pyjSs_Q_at_mail.gmail.com>



On Wed, May 4, 2011 at 4:28 PM, Jared Still <jkstill_at_gmail.com> wrote:

>
> t.created between to_date('10/01/2009', 'MM/DD/YYYY')
> and to_date('09/30/2010', 'MM/DD/YYYY')
>
>

Oops.

That should be t.created between to_date('10/01/2009', 'MM/DD/YYYY') and to_date('10/01/2010', 'MM/DD/YYYY') - (1/86400)

Eagle eyed Brendan Fleming caught that.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 05 2011 - 10:04:37 CDT

Original text of this message