convert date to string

[jesse1]

I am embarrassed to ask this but I am going crazy.

I am using the following query.

<cfquery name="dddd"  username="rrrr" password="ddddd" datasource ="ggggg">
   select  sched_date, districth, districta, gameid, hour, minutes, meridian 
    from spSchedule 
    where sched_date = #createodbcdate(Now())#
</cfquery>

The problem is sched_date is a varchar(50). This happened when the database was converted to mySql. Converting it to a date field is not an option at this time due to other programmers.

The code does not work I assume because I am comparing a string to a date.

 

[jesse1]

Nevermind
'#dateformat(now(), 'mm/dd/yyyy')#'