Click here to Skip to main content
11,571,155 members (68,145 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Oracle
How about if you need to pick the last 3 months prior to sysdate?


For example:

variable rundate varchar2(15);
execute :rundate :=to_char(sysdate);
 
variable Month1 varchar2(15);
execute :Month1 :=add_months(:rundate,-3);


But I only want orders in month vs. since exact date. If today is Mar 23, 2013 and I want previous month's order data, I don't want data from Feb 23rd to now. I just want Feb-13 orders.

How would you do that?



Thanks,
Adam
Posted 23-Mar-13 13:12pm
Edited 24-Mar-13 1:16am
Maciej Los186.5K
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

try this
variable Month1 varchar2(15);
execute :Month1 :=to_char(add_months(:rundate,-3),'MON-DD');
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Thank you. I tried the to_char previously but didnt work. But seems to be fine now.
  Permalink  
Comments
pryashrma at 25-Mar-13 1:02am
   
post d reply to solution in comment section! to send notification to the member

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | Last Updated 24 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100