Click here to Skip to main content
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 14:12pm
Edited 24-Mar-13 2:16am
Maciej Los158.9K
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
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 95
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 24 Mar 2013
Copyright © CodeProject, 1999-2014
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