PEGA Function Alias for Converting GMT To CET Timezone
For Postgres SQL use CAST(({1}::timestamp AT TIME ZONE 'GMT') AT TIME ZONE 'Europe/Brussels' AS timestamp) In function alias source. For Oracle SQL use CAST((FROM_TZ(CAST({1} AS TIMESTAMP),'GMT') AT TIME ZONE 'Europe/Brussels') AS TIMESTAMP) Input parameter name = P1 Data Type = DateTime Type = Autocomplete