4 Replies Latest reply on Jul 3, 2019 7:35 AM by Zi Sang

    Smart Reporting - The function Hour () will convert the timestamp 12:00 am to 0:00, instead of 12:00

    Zi Sang
      Share This:

      In Smart Reporting, in calculation field, if i used hand SQL to call the function Hour (), it will convert the timestamp 12:00 AM to Hour 0:00

      However, this is wrong, it should be converted to 12:00

       

      Does anyone have the same problem as me?