Thank you all very much for helping me. It looks like Oracle stores date
only in one timezone in one
database. I was able to do the format conversion using:
select to_char(sysdate, 'Dy Mon DD HH24:MI:SS "PDT" YYYY') from dual;
TO_CHAR(SYSDATE,'DYMONDDHH24
----------------------------
Mon Oct 01 16:36:41 PDT 2001
insert into test1
values (to_date('Thu Sep 20 15:03:10 PDT 2001',
'Dy Mon DD HH24:MI:SS "PDT" YYYY'));
If there is datetime from other time zone, I'll have to convert or calculate
them into the PDT timezone first,
then store them.
Thanks again,
Jie
"Bruce W. Hoylman" wrote:
> In 8.1.6 for Solaris, browse standard.sql. There are numerous
> functions, internal data types and overloaded operators that support
> manipulation/display of time zone formats.
>
> HTHYO.
>
> >>>>> "Mark" == Mark Vandenbroeck <[EMAIL PROTECTED]> writes:
>
> Mark> Jie, Oracle doesn't support timezones in date format strings,
> Mark> unfortunately.
>
> 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');
> >> >
