Skip to Main Content

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!

Date Range - last month

2896536Mar 4 2015 — edited Mar 4 2015

Hi community,

first: I'm new to Oracle Databases...

I need to query our ERP-System Database and want to select data from last month every time I run the query-

i.e. today (march, 4th) the query should select all records between 1 Feb and 28 Feb.

I'm playing around with Sysdate -1 etc. but can“t find a solution.

thanks

Heiko

This post has been answered by John Stegeman on Mar 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2015
Added on Mar 4 2015
31 comments
7,751 views