Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> comparing a date?

comparing a date?

From: Mark Harrison <mh_at_pixar.com>
Date: Tue, 20 Jun 2006 21:43:58 GMT
Message-ID: <y_Zlg.69786$4L1.61885@newssvr11.news.prodigy.com>


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 Studios
Received on Tue Jun 20 2006 - 16:43:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US