Billy Cox wrote: > If I understand the question properly, here is today's date in literal > format: > > '2007-08-10'
That is what I expected, but this failed. SELECT aField FROM aTable WHERE aDateTimeField >= '2005-07-01' Apparently Oracle needs a DATE command in there. This is what worked SELECT aField FROM aTable WHERE aDateTimeField >= DATE '2005-07-01' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
