9i is a lot more timezone aware - if thats of any use. You can have a data type of "TIMESTAMP WITH [LOCAL] TIMEZONE", however I'm not sure of whether the Oracle::DBD supports the new data types.
-----Original Message----- From: jie zhang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 3 October 2001 9:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Mark Vandenbroeck Subject: Re: date format in Oracle 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'); > >> >
