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

    From 12 to 24 fomat problem

    Michael Canseco

      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?

      Thanks!