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:
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-lReceived on Thu May 05 2011 - 10:04:37 CDT