Date comparison in Oracle database

Posted by Jasim on Stack Overflow See other posts from Stack Overflow or by Jasim
Published on 2010-05-26T11:05:24Z Indexed on 2010/05/26 11:11 UTC
Read the original article Hit count: 166

Filed under:
|
|

I have two variable TO_DATE and FROM_DATE. My table has two fields DOJ and DOL. I want to select all the records whose DOJ < TO_DATE and DOL > FROM_DATE.

How can i write an SQL query in for this??

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about date