Re: Query output based on date - Oracle 8i

["lazyvalet" <webforumsuser@xxxxxxxxxxxxxx>]

Perhaps a step in the right direction. 

 I now have:

 select * from my.table
 where startdate > <CFQUERYPARAM VALUE="#01/01/2008#' 
CFSQLTYPE="CF_SQL_NUMERIC">

 Now I get an error of:

 [ODBC][Ora]ORA-01847: day of month must be between 1 and last day of month

 Tried a few methods of formatting the month, but no dice.