This content has been marked as final. Show 5 replies
Hi, i have some data(timestamp) with the next format:
01:00 a. m.
01:01 a. m.
01:02 a. m.
and so on..
I need this to be in 24 format, im trying with this:
Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'h:mm:ss TT') ,'hh:mm:ss') as MyTimeStampFieldin24HrsFormat
also im trying this formats:
h:mm T. T.
h:mm T T
none of this seems to work. do you have any idea how i can do this?