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');
>> >
