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!

How to write a exclude condition for dates?

SeshuGiriJul 3 2014 — edited Jul 31 2014

I want to exclude all dates from my query and get data from 01-JAN-14 to 31-JAN-14.

SELECT * FROM SCHEMA.SELLING WHERE  ( SELLDATE  < '01-JAN-14' OR SELLDATE > '31-JAN-14')

Note: This query maybe written using different ways, but I want to specifically know how to exclude.

Right now above query is getting data which does not fall into that range.

1 LEDTV 1/1/2010

2 BLURAY 8/3/2011
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2014
Added on Jul 3 2014
#query, #sql
12 comments
5,367 views