Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Format Mask to show Date and Time in Local time Zone

HawkerHunterSep 28 2021 — edited Sep 28 2021

Hello Friends,
In one of my Create/Update forms I am trying to show the date time in Local time zone.
In my database table the data type of these fields is TIMESTAMP WITH TIME ZONE and I am saving the data in UTC.
If I use the Format Mask for the Date fields in my Create/Update form as DD-MON-YYYY HH:MI:SS PM, it shows the UTC time.
I searched the format mask which will convert it to Local date time but could not find.
It would be great help if some one can let me know.
Thanks & Regards
Hawker

Comments
Post Details
Added on Sep 28 2021
3 comments
1,859 views