Find record based on some common date range

Question

Dear all friends I have one table in which some records of some retailers.... Now i want to find only which records that have purchased or bought in only there months (i.e. Jan - Feb - March records must be in three months). Kindly suggest me... Thanks .

Saillesh Pawar · Answer

Twist accordingly in sql server this sample is in oracle create or replace PROCEDURE ORDER_DETAILS_sample ( Cur_out out SYS_REFCURSOR ) as v_year numeric; v_date varchar2(20); begin select to_char(sysdate 'YY') into v_year from dual; open Cur_out for select * from tc_order_MASTER where to_char(ORDER_CREATED_DATE'Mon-YY') in ('Jan-'||v_year'Feb-'||v_year'Mar-16-'||v_year); end; variable x refcursor; execute ORDER_DETAILS_sample(:x) print :x;

Rajeev Punhani · Answer

Hi Yogesh Please find the below query. SELECT * FROM TABLE_NAME WHERE Date_Column >= DATEADD ( MONTH  -3  GETDATE ()) If the above solution is helpful then accept the answer.