7 Replies Latest reply: Apr 16, 2014 2:22 AM by Ram Asokan RSS

    Time format.

    Ram Asokan

      Hi folks,

       

      Can anyone advise me on how could I convert the time dimension from 24-hour to 12-hour format?

       

      Sample script:

       

      Time_DIM:

      Load

           time(frac(time_column),'HH12:MM:SS AM/PM');

           @or

           time(frac(time_column),'HH12:MM:SS');

      From Time_DIM.xls;

       

      Thanks.

       

      Best Regards,

      R