Re: help me, optimize a long running query
Posted by:
Rick James
Date: December 27, 2011 10:00PM
Since PubDate seems to be a DATE, use
date_add(CURRENT_DATE(), interval -7 day)
Subject
Views
Written By
Posted
3397
October 25, 2011 12:00AM
1380
October 26, 2011 06:48AM
1368
October 27, 2011 12:39AM
1460
October 27, 2011 09:04PM
1742
December 26, 2011 11:52PM
Re: help me, optimize a long running query
1241
December 27, 2011 10:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.