Skip to main content
C
cfnew
Known Participant
November 19, 2009
Answered

problem with select query in search

  • November 19, 2009
  • 2 replies
  • 346 views

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 .

This topic has been closed for replies.
Correct answer ilssac

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

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

2 replies

ilssac
ilssacCorrect answer
Inspiring
November 19, 2009

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

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

B
Boubaker_Moussa
Participant
November 19, 2009

Try to use DateFormat

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



Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices