Community discussion forum

How do I modify this query ?

• • Reply

  1 year ago

  by suryaprakash

  Surya Prakash K K

  , India

  Joined 1 year ago

   Hi, I have written a query that returns all the days of 12th month, 2006 year.
  
  "SELECT * FORM  conDate WHERE engdate LIKE '%[dd]%2006%'"
  
  How do I modify this query so that it returns all days of ,say 5th month,2006.
  
  Thanks.
  
  

  Report abuse
• • Reply

  1 year ago

  by suryaprakash

  Surya Prakash K K

  , India

  Joined 1 year ago

  Hi

  I have solved it myself.
  

  Here's the query that returns all days of 5th month, 2006

   

  SELECT  engdate

  FROM         conDate
  WHERE     (engdate >= '5/1/2005') AND (engdate < '6/1/2005')

   

  Regards. 

   

   

  Report abuse
• • Reply

  1 year ago

  by khari6579

  Hari K

  Chennai, India

  Joined 4 years ago

  Hi

   One more method.

   SELECT engdate FROM ConDate

   WHERE MONTH(endDate)=5 AND YEAR(endDate)=2006

  Regards

  Hari K....

  Report abuse