Enquiries on searching date using Between function 'merged 3) [message #396254] |
Sun, 05 April 2009 23:01  |
setsuna
Messages: 32 Registered: November 2008
|
Member |
|
|
Hi there,
I had some enquiries refarding thest 2 statement. When I key in the following statment.
SELECT target_date FROM table_1
WHERE target_date
BETWEEN to_date(sysdate,'dd/mm/yyyy')-5
AND to_date(sysdate,'dd/mm/yyyy')-3
no rows selected -- is displayed
However, when I use the next following statement.
SELECT target_date FROM table_1
WHERE target_date
BETWEEN to_date(sysdate,'dd-mm-yy')-5
AND to_date(sysdate,'dd-mm-yy')-3
I am able to retrieve the target_date. May I know why is this so?
Rgds
Setsuna
|
|
|
|
|
|
|