Re: Query output based on date - Oracle 8i

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

You can use the Oracle to_date() function to convert your string to a date/time 
object:

 select * from my.table
 where startdate > to_date('2008-01-01', 'YYYY-MM-DD')

 Or, since you are using an ODBC connection to Oracle, you can try using the 
ColdFusion CreateODBCDate() function:

 select * from my.table
 where startdate > #CreateODBCDate("2008-01-01")#

 Or, as already suggested, use cfqueryparam with the appropriate CFSQLType. You 
can't use a "string" date value against a date/time column in an Oracle query, 
as it won't perform an implicit type conversion.  

 Phil