Select from table by knowing only date without time (ORACLE)
- by Abdulrhman
Greeting People,,
I'm trying to retrieve records from table by knowing the date in column contains date and time.
let me explain my self clearly with this example:
suppose i have table called t1 which contains only two column name, date respectively
the data stored in column date like this "8/3/2010 12:34:20 PM"
i want to retrieve this record by this query for example:
Select * from t1 where date="8/3/2010" // notes i don't put the time.
this query give me nothing !
SO now my question is how can i retrieve date by knowing only date without the time !
