Function to convert time to AM or PM format
Hi,
As per my requirement i am getting ProcessedDate== "2024-05-10 07:29:31.271", from here i have taken a sub string i.e, 2024-05-10 and i need to convert 07:29:31.271 to 07:29 AM/PM.
How to accomplish this requirement by using function. EG: I need Output like this 05/10/2024 - 07:29 PM
Accenture
IN
Hi @srikavyav,
Hope the below link helps
https://support.pega.com/question/convert-time-format-hhmmss-hhmmss-ampm
Thanks.
Pegasystems Inc.
IN
You can use FormatDateTime to convert the date format or use custom java code in an activity.
HCA Healthcare
US
@srikavyav You can use Python's datetime module to convert the timestamp. First, parse the input string 2024-05-10 07:29:31.271 using datetime.strptime with the format "%Y-%m-%d %H:%M:%S.%f". This converts it into a datetime object. Then, use strftime to format the date as "%m/%d/%Y" for MM/DD/YYYY and the time as "%I:%M %p" for 12-hour AM/PM format. Finally, combine the formatted date and time with a hyphen (-) in between. For example, input "2024-05-10 07:29:31.271" will give the output "05/10/2024 - 07:29 AM". This is done in a few steps using parsing, formatting, and concatenation