Somehow, TZ is not recognized in my system. I am using oracle 8.1.7 on
solaris 5.8.
Did you actually tried out in your system ? Do I need to
set up any NLS variable in order to use the 'TZ' keyword ?
Thanks,
Jie
Anna Fong wrote:
> 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
