hi ,
Is there any way to find the short timezone as
AST,BST,CST,EST etc from SYSTIMESTAMP.
thanx.
sam
Printable View
hi ,
Is there any way to find the short timezone as
AST,BST,CST,EST etc from SYSTIMESTAMP.
thanx.
sam
Is that you are looking for?PHP Code:
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.
Tamil