Convert timestamp with am/pm in field to date

sysdradmin · September 8, 2018, 9:43am

Hello,

we have a field named 'timestamp' with the format : "12/09/2018 01:02:10 AM" or " 01/05/2018 05:04:01 PM"

how to convert it to date format ?

i don't know how to delete 'AM' or 'PM' to real time...
thks for help

rgds

sysdradmin · September 8, 2018, 9:59am

found ... need to add aa to match filter

sysdradmin · September 8, 2018, 10:32am

but i only see am time not pm time

sysdradmin · September 8, 2018, 10:44am

found. prefer use hh instead of HH

system · October 6, 2018, 10:44am

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.