SunOS oracle 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V210
Oracle 9.2.0.1.0
Делаю так:
create table T2 (ts TIMESTAMP WITH LOCAL TIME ZONE)
insert into "SPROOT"."T2"
values (TO_TIMESTAMP_TZ('2004-04-30 23:03:50.914133+11','YYYY-MM-DD HH24:MI:SSXFFTZH'))
select * from "T2"
1 record(s) affected
[Executed: 04.10.05 15:00:11 VLAST ] [Execution: 16/ms]
TS
--------------------------
2004-04-30 23:03:50.914133
1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]
[Executed: 04.10.05 15:00:11 VLAST ] [Execution: 4/ms]
Установки такие:
PARAMETER VALUE
----------------------- ---------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT yyyy-mm-dd hh24:mi:ssxff
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT YYYY-MM-DD HH24:MI:SSXFFTZH
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
19 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 3/ms]
[Executed: 04.10.05 15:02:28 VLAST ] [Execution: 4/ms]
Почему при селекте я не вижу таймзоны ?
timestamp tz
Модераторы: Trinity admin`s, Free-lance moderator`s
Кто сейчас на конференции
Сейчас этот форум просматривают: нет зарегистрированных пользователей и 34 гостя