Forum Stats

  • 3,852,417 Users
  • 2,264,102 Discussions
  • 7,905,063 Comments

Discussions

Unable to display time zone offset in e-text template

Vivek Kumar S
Vivek Kumar S Member Posts: 1 Red Ribbon

We are trying to display sysdate with time zone offset in e-text using below function and its not working. Since it's 'Disbursement Payment File Format' seeded report, we are unable to get it from data model.

FORMAT_DATE(SYSDATE, ‘YYYY/MM/DD HH24:MI:SS TZH:TZM’)

Answers