2 Replies Latest reply: Mar 28, 2012 2:09 PM by Gonçalo MAchado RSS

    SET a Time to a Timestamp



      Do you know how to set a time, in the timestamp.

      Ex: If a process entry date is: 26/03/2012 01h56.

      A working day starts at 8h00, so I want to store the value 26/03/2012 08h00.


      if(hour(entry_date) < 8, ??Set(entry_date, 8h00)??, entry_date) as entry_working_date


      Do you know a simple way to do it?