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

    SET a Time to a Timestamp

      Hi,

       

      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?

       

      Regards,

      Gonçalo