Re: to_char in a where clause [message #1650] |
Fri, 17 May 2002 08:17 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
SQL> ED
Wrote file afiedt.buf
1 select * from emp where to_char(hiredate,'DD-MM-YYYY')=TO_char(to_date('17-12-2002','DD-MM-YYYY
2* 'DD-MM-YYYY')
SQL> /
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-02 800 20
|
|
|