Help with EText Template – Convert SYSDATE from UTC to Malaysian Time (MYT) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!