How to add 6 hours on MSSQL with format

Question

I am currently using

SELECT FORMAT (getdate(), 'MM/dd/yyyy, hh:mm:ss tt') as date

The output is in the format I need, but is off by 6 hours.

05/30/2019, 06:26:01 PM

I just need to add 6 hours to it. been using dateadd, but I keep loosing the format I need it to be on.

SELECT DATEADD(Hours,6,GETDATE()) outputs in wrong format

Answer 1

You need to call the DATEADD function inside the FORMAT function:

SELECT FORMAT( DATEADD(HOUR, 6, GETDATE()), 'MM/dd/yyyy, hh:mm:ss tt') as date

Answer 2

Declare @dt datetime ;
select @dt=  DATEADD(Hour,6,GETDATE())
SELECT FORMAT (@dt, 'MM/dd/yyyy, hh:mm:ss tt') as date