上了10G和准备上10G的朋友小心点

henrybai · 发表于 2007-10-24 16:41

solaris platform.
oracle support's feedback:

Unfortunately there is no other way - just changing application code...

I think there is a misunderstanding here!
The TO_TIMESTAMP_TZ function has NOT changed in 10g - 9i documentation is the same as 10g documentation:
"
TO_TIMESTAMP_TZ converts char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to a val
ue of TIMESTAMP WITH TIME ZONE datatype.

--------------------------------------------------------------------------------
Note:
This function does not convert character strings to TIMESTAMP WITH LOCAL TIME ZONE. To do this, use a CAST fun
ction, as shown in CAST.

"

We all know that we may benefit from implicit conversions, BUT, there may be a side effect of sub-optimal plans...

Anyway, such upgrades from 9i to 10g should be carefully planned and extensive testing on test
env should be done before moving production...

henrybai · 发表于 2007-10-24 16:42

换到10G想修改CODE。想升级的朋友做好准备哟！

lfree · 发表于 2007-10-24 16:50

CREATE INDEX SCOTT.TT_F_IND ON SCOTT.TT
(sys_extract_utc(X) )
那你实验了这个没有。

lfree · 发表于 2007-10-24 16:51

我没有solaris 的10g的版本，无法做这个测试。
我觉得应该与linux一样的。

lfree · 发表于 2007-10-24 16:53

我在linux的测试结果就像上面一样使用了一个转换函数。
sys_extract_utc
http://download-uk.oracle.com/docs/...unctions152.htm

SYS_EXTRACT_UTC extracts the UTC (Coordinated Universal Time—formerly Greenwich Mean Time) from a datetime value with time zone offset or time zone region name.