Fellows,
Is there simple way to extract the TimeZone(EST, PST) value from 'Select dbtimezone from dual'.
My current format setting reports: -5:00 (see below)
select dbtimezone from dual;
DBTIME
------
-05:00
I understand that I can set this Parameter to 'PST' on the init.ora file, but I would rather not.
Is there anyway to extact or convert this value to return 'PST'.
Please assist
Is there simple way to extract the TimeZone(EST, PST) value from 'Select dbtimezone from dual'.
My current format setting reports: -5:00 (see below)
select dbtimezone from dual;
DBTIME
------
-05:00
I understand that I can set this Parameter to 'PST' on the init.ora file, but I would rather not.
Is there anyway to extact or convert this value to return 'PST'.
Please assist