Help with EText Template – Convert SYSDATE from UTC to Malaysian Time (MYT)
Summary:
Hi All,
How can I convert or adjust SYSDATE
to Malaysian Time within an EText Template?
Any guidance, workaround, or example from your experience would be highly appreciated!
Content (please ensure you mask any confidential information):
The goal is to prevent the generation of payment files with a date earlier than the current date (Malaysian time). Since the default SYSDATE
is in UTC, there's a risk that a payment processed after midnight UTC but before 8:00 AM MYT would be seen as "yesterday’s" date.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):