How can I query an Oracle Date field as an int? I am trying to find rows that are 3 days old and the date fields in Oracle are timestamps. I need to some how ignore the time in the date field in the query
This is what I have tried: <cfquery name="Thirdday" datasource="badge_access_dsn"> SELECT * FROM SPS_NON_MOT_BPS.SITES WHERE ((int(CREATION_DATE) <= int(now())-3 AND Badging_status = 'In Approval Cycle') OR (Badging_status = 'In Renew Cycle' AND int(MODIFY_DATE) <= int(now())-3)) AND (SUPPLY_MGMT_APPROVAL_STATUS = '' OR M_CONTACT_MGR_APPROVAL_STATUS = '') </cfquery> I get an error of: [ODBC Oracle driver][Oracle]ORA-00904: invalid column name Regards, Patrick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4