Re: Just as a learning exercise
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx
- Date: Wed, 4 May 2011 14:37:51 +0100
In the example given the logic is the same with and without the trunc the
execution plan likely won't be if there is an idex on the column and the
query is fairly selective (which I doubt) .
On 4 May 2011 14:33, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
to truncate the time component?
Joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
From:
Paul Drake <bdbafh@xxxxxxxxx>
To: tomdaytwo@xxxxxxxxx Cc: oracle-l <oracle-l@xxxxxxxxxxxxx> Date: 05/04/2011
09:23 AM Subject: Re: Just as a learning exercise Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
------------------------------
Thomas,
Why would anyone ever apply a TRUNC ( ) function to a date column in a where
clause?
Is...
Other related posts:
