Re: Just as a learning exercise
- From: Jared Still <jkstill@xxxxxxxxx>
- To: tomdaytwo@xxxxxxxxx
- Date: Thu, 5 May 2011 08:04:37 -0700
On Wed, May 4, 2011 at 4:28 PM, Jared Still <jkstill@xxxxxxxxx> 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
Other related posts:
