5 Replies Latest reply: Dec 15, 2016 12:54 PM by Tamil arasu RSS

    From 12 to 24 fomat problem

      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.

      h:mm T T

      none of this seems to work. do you have any idea how i can do this?