Use Oracle's to_date function. Example:
select ename, hiredate
from emp
where hiredate = TO_DATE('Thu Sep 20 15:03:10 PDT 2001','DY MON DD
HH24:MI:SS TZ YYYY');
At 03:58 PM 10/01/2001 -0700, jie zhang wrote:
>Does anybody know if Oracle can take the date format as 'Thu Sep 20
>15:03:10 PDT 2001') ?
>
>Thanks in advance,
>
>Jie
>
>
--------------------------------------------------------
Anna Q. Fong, Webmaster
California Data Exchange Center
