Oracle Fusion Date Format Conversion based Time Zone

 1) System Preference Defined Timezone based Date

SELECT

(cast(SYSDATE as timestamp) AT TIME ZONE FND_GLOBAL.TIMEZONE) DT

FROM Dual

2) Convert Date From One Timezone to another Timezone

select 

TO_CHAR(FROM_TZ(CAST(SYSDATE AS TIMESTAMP), 'GMT') at time zone 'Asia/Dubai','dd-Mon-yyyy HH24:mm:ss') D2 

from dual