1 Reply Latest reply: Jun 1, 2012 12:02 AM by Sokkorn Cheav RSS

    Need to add hours

    Hairul Annuar Mohd Khaliluddin

       

      Currently my MSSQL column for time is past due 8hours, therefore I need to add another 8hours

       

      eg: current 07:28:30 need to be 15:28:30

       

      Below are the script that been tried but not meet my needs

       

           Time(("TMS & WMS Push Date"),'hh:mm:ss')+8:00:00

                   Time(("TMS & WMS Push Date"),'hh:mm:ss')+8

       

      Please advise.