post your table or query definition. Adding time works exactly the same as adding days.

https://msdn.microsoft.com/en-us/library/ms186819.aspx