20230830 - Local Timezone

select trunc(cast(from_tz(cast(SYSDATE as timestamp ), to_char(systimestamp, 'TZR')) at time zone 'Asia/Seoul' as date)) from dual

select trunc(cast(from_tz(cast(SYSDATE as timestamp ), to_char(systimestamp, 'TZR')) at time zone 'Asia/Kuala_Lumpur' as date)) from dual