How can I get only the time in advance 8 hours for example it is 12 PM and an event will happen at 20 Hours Server.
If I do this I will get 8 days but I need to do the same but in Hours .
SELECT GETDATE()+8
How can I get only the time in advance 8 hours for example it is 12 PM and an event will happen at 20 Hours Server.
If I do this I will get 8 days but I need to do the same but in Hours .
SELECT GETDATE()+8
More information: https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-2017
Try making this select:
in either case you will get the time but 8 hours in advance.
Ref: https://docs.microsoft.com/en-us/sql/t-sql/functions/current-timestamp-transact-sql?view=sql-server-2017