37 Replies Latest reply: Jun 4, 2015 12:06 PM by pratap budati RSS

    Rounding timestamp to hour

    Venkata Gogineni

      Hello Everyone,

      I have a field called readtimestamp% . we have some books where people read we get timestamp. we need to find how many people read per  hour on a day.

      It has something like

      02/02/2014  01:07:00  

      02/02/2014  00:00:14

      How can i round them to

       

      02/02/2014  01:00:00

      02/02/2014  00:00:00

       

      Thanks,

      Venkata