Jie,
Oracle doesn't support timezones in date format strings, unfortunately.
Brgds,
Mark
jie zhang wrote:
> 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
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
Business Process Manager Email : [EMAIL PROTECTED]
EMEA Support Information Systems AIM : markvdb
