to convert systimestamp to Any other time zone

The fuction is from_tz

SELECT FROM_TZ(to_timestamp(to_char(systimestamp,'DD-MON-YYYY HH:MI:SS PM')) ,'+05:30') AT TIME ZONE '-06:00',systimestamp from dual;

and one more fn.

select LOCALTIMESTAMP AT TIME ZONE '-6:00' from dual;