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








Comments

Post a Comment

Popular posts from this blog

Frequently Used Date Expressions In Pega

-
Image
 Hi, In this post I will show some of the frequently used date expressions in pega. Before starting we will see some of the date subscripts used in date functions. For Ex:   If date is =  05/March/2023 yyyy = Year => 2023 YYYY => 2023 MM = Month => 03 M=> 3 MMMM  ===> March MMM ====> Mar dd = Date/day  => 05 d ===> 5 1) pxFormatDateOnly(CurrentDateTime(),"yyyyMMdd","MM/dd/yyyy")   Here, CurrentDateTime()  = 20230618T025027.005 GMT                                                                                CurrentDateTime() returns the current date and time. pxFormatDateOnly() = Format/reformat a Date Time string using a specified parameters. Output  =  06/18/2023  { which is 18 June 2023} 2)...
Read more

pxSubscript and pxListSubscript Properties In Pega

-
Image
  .pxSubscript   And  .pxListSubscript Property-Set                         CasePg.Stakeholderlist Param.Indexpurpose  = "Index_Stakeholderlist" Param.InsIndexedKey  =  "CIGNA-CIGNAAUTO-WORK"+CasePg.pyID local.cnt  =   .pxListSubscript Param.IndexCount = local.cnt-1 How to get index value from pagelist?  The property pxListSubscript will hold the index of the current page that you are in How to get index in a pagelist during iteration While iterating in a pagelist Example : EmployeeList To refer to page at that point: we use EmployeeList(<CURRENT> ) But how to get the index if we have to write some condition, like at index= nth position => achieve some logic. Answer : pxListSubscript Pega provides one property called pxListSubscript which is declaratively calculated and kept at each page level in a pagelist. We can use it instead of setting  a property a...
Read more

Email Sending Activities In Pega

-
Image
Hi, In this blog we will see some of the OOTB email sending activities in pega. SendEmailNotification SendSimpleEmail SendEmailWithAttachments 1) SendEmailNotification This activity is present in @baseclass.  Description = Sends Email Correspondence. This activity basically gathers all the parameters for email and passes them to send email function . From: It accepts email address as per Email Address specification defined in RFC with only lcoal part and domain seperated by @ To/CC/BCC : It accepts one or more email addresses separated by "," or ";".Email Address should adhere to internet email address specification as defined in RFC. It is recommended separating email addresses with "," when there are multiple email addresses. Please note the below limitation when email address contains display name with ";" in it. Semicolon is replaced by comma when message is delivered to the email server which might cause issues when display name is used in ...
Read more