Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to add hours

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.

1 Reply
Sokkorn
Master
Master

Hi,

Try this Interval('7:00:00' + '08:00:00','hh:mm:ss')

Regards,

Sokkorn