Re: comparing a date?

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';

GM Received on Tue Jun 20 2006 - 18:27:12 CDT