| Re: working with dates [message #1817] |
Sun, 02 June 2002 08:13 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you cannot equate sysdate. becasue sysdate itself is constantly changing.
so either you need to trimm of the HH:Mi:ss date
or instead of using between operator use
> and < operator like
select tickets from cases where
status = 'Open' and datecreated > sysdate -5 and datecreated < sysdate -10 ;
select tickets from cases where
status = 'Open' and datecreated < sysdate -5 and datecreated > sysdate -10 ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
