Our Training Programs

All contents are copyright of their authors.

Find record based on some common date range

Find record based on some common date range

Yogesh Sharma

10yAsked Mar 18, 2016, 1:43 AM893Visual Basic .NET

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 .

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Saillesh Pawar10y ago
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 Punhani10y ago
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.