Geoff Muldoon <geoff.muldoon_at_trap.gmail.com> wrote:
> mh_at_pixar.com says...
>> 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?
>
> select * from all_users where trunc(created)='20-JUN-06';
... and the explanation is that DATE does not store a date, but a
timestamp. In your table the hour, minute, and second values of the
DATEs are nonzero.
Yours,
Laurenz Albe
Received on Wed Jun 21 2006 - 04:05:12 CDT