Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to compare a date to sysdate
A-Friend schrieb in Nachricht <7blp9j$dmu$1_at_fe2.cs.interbusiness.it>...
>SQL> select * from tab1row where to_char(readdate,'dd-mon-yyyy') =
>to_char(sysdate,'dd-mon-yyyy');
You should think about
SQlL> select * from tab1row where trunc(readdate) =trunc(sysdate);
Received on Thu Mar 04 1999 - 12:49:59 CST