date

[santo]

hi ,

Is there any way to find the short timezone as
AST,BST,CST,EST etc from SYSTIMESTAMP.

thanx.
sam

[tamilselvan]

select * from v$timezone_names ;

TZNAME         TZABBREV
-------------- -------------
US/Pacific     PDT
US/Pacific-New LMT
US/Pacific-New PST
US/Pacific-New PWT
US/Pacific-New PDT
US/Samoa       LMT
US/Samoa       SAMT
US/Samoa       NST
US/Samoa       BST
US/Samoa       SST
W-SU           LMT

TZNAME         TZABBREV
-------------- -------------
W-SU           MMT
W-SU           MST
W-SU           MDST
W-SU           S
W-SU           MSD
W-SU           MSK
W-SU           EET
W-SU           EEST
WET            LMT
WET            WEST
WET            WET

1286 rows selected. 

Is that you are looking for?

Tamil