Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Greater Than Less Than

Chanchal WankhadeJan 19 2012 — edited Jan 20 2012
Dear all,

I am Using oracle 10g R2 database on windows. 
I have a doubt that,
If I have a 'Date' datatype column suppose a and want to (select Less than sysdate and greater than Sysdate-31(One Month).
e.i.
select a,b,c from T where a Less Than Sysdate-31(One month.);
How can i do this.


Thanks,
Chanchal Wankhade.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2012
Added on Jan 19 2012
9 comments
10,943 views