problem with select query in search

[cfnew]

Hi,

Here i am using MYSQL database and when i am insertind date to database it is saving like  '2009-11-10 00:00:00'  and when i used to dispaly this in dateformat as '11/10/2009' .

here is the problem occurs , when i write a search query as

select recruitername,interviewdate ,skillset
             from details
              where interviewdate = #form.interviewdate#

i am getting problem with date . would u please help me how to solve this issue .

[Boubaker_Moussa]

Try to use DateFormat

select recruitername,interviewdate ,skillset
             from details
              where interviewdate = #DateFormat(form.interviewdate, "yyyy-dd-mm")#

[ilssac · Accepted solution]

Or better yet, a <cfqueryparam...> with a date type.

WHERE interviewdate = <cfqueryparam value="#form.interviewdate#" cfsqltype="cf_sql_date">