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