If you are comparing to now(): SYSDATE + 1 is tomorrow SYSDATE â 7 is one week ago SYSDATE + (10/1440) is ten minutes from now
>Im just getting my feet wet with Oracle, > >I have a CF app that generates an RSS feed. The client want's to keep topics >up for a week. How would I determine if a week has passed > >IE: if date posted is less than or equal to #now()# - 7 days > >I need to due this in the SQL Statement, cause the feed is generated from a >CF output... > >Thanks > >Scott A. Stewart >ColdFusion Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:187634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
