Closed
How to handle Time hh:mm in Pega from SQL.
I getting data from SQL, In SQL Time datatype using, with the format hh:mm
I need to use in Pega for adding some more hours to that time.
Please suggest how to handle time (hh:mm) in pega, and how to add some hours to that time (any specific Function is available in pega)
***Edited by Moderator: Pooja Gadige to add capability tags***
To see attachments, please log in.
Posted: 2 years ago
ING Nederland
ING Nederland
NL
Hi @GokulR88, can you try this way and let us know if it works as per the expectation:
Store the "HH:mm" value in a param, let's say, Param.MyTime and then in the next step add this function to add "+X" hours to the original value:
@toInt(whatComesBeforeFirst(Param.MyTime,':'))+2
Store this to another param value and change the value of "+2" to the number of hours to wish to add.
Hope this helps!
Thanks,
Saurabh.