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.