If I understand the question properly, here is today's date in literal format:
'2007-08-10' -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 9:28 AM To: CF-Talk Subject: SQL Date Literal Syntax I think I'm getting old. I've been using <cfqeuryparam...> so long I can apparently no longer remember how to properly pass a data literal in a SQL statement. I'm trying to run a query through SQL Plus to our Oracle DBMS to compare to my CF template results. Obviously SQL Plus is not going to parse <cfqueryparam...> tags. I need to get records where a date-time field is between two date literals. How do I properly designate a date literal in this SQL statement? Apparently the SQL string generated by CF is not what SQL PLus will accept, copying and pasting it fails. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
