Search Records Based on Custome Date Range

Question

Dear all friends here some months as... 12 Dec 01 Jan 02 Feb Then i want find records which is belongs to these three months.. The resulted records must be in Dec jan and Feb.....

K P Singh Chundawat · Answer

try this Get Month from you given Date and Pass it as where condition in your sql query. I am using here month function of SQL severe. SELECT * FROM youtable WHERE MONTH ( youcolumnName ) =yourMonth --Month should be numeric.

Imtiyaz Ansari · Answer

Hi Yogesh you can used IN operator ex. Select * From TableName where month in ('Dec''Jan''Feb')