Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> comparing a date?
How do I compare a date to be equal to a particular day?
For example, here's some dates in the all_users table:
select * from all_users;
USERNAME USER_ID CREATED ------------------------------ ---------- --------- MAB 235 20-JUN-06 MPLANCK 234 20-JUN-06 TBEST 233 20-JUN-06
but if I just check for date equality, I don't match any rows:
SQL> select * from all_users where created='20-JUN-06';
no rows selected
This query does the right thing:
select * from all_users where created>'20-JUN-06' and created<'21-JUN-06';
What's the proper way to compare a date column for a particular day, without respect to the time?
Thanks!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Tue Jun 20 2006 - 16:43:58 CDT