Timeline for How to add 6 hours on MSSQL with format
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 31, 2019 at 9:51 | vote | accept | lviz | ||
| May 31, 2019 at 9:51 | comment | added | lviz | Thanks, I figured that is what I needed to do. just cant do it right, thanks | |
| May 31, 2019 at 0:30 | answer | added | HandyD | timeline score: 0 | |
| May 30, 2019 at 17:03 | comment | added | Jonathan Fite | Or change the server to the desired timezone... | |
| May 30, 2019 at 16:35 | comment | added | ypercubeᵀᴹ |
So, why don't you combine the two?: SELECT FORMAT(DATEADD(Hours,6,GETDATE()), 'MM/dd/yyyy, hh:mm:ss tt') AS date ;
|
|
| May 30, 2019 at 16:35 | review | First posts | |||
| May 30, 2019 at 17:06 | |||||
| May 30, 2019 at 16:33 | answer | added | Vinod Narwal | timeline score: 0 | |
| May 30, 2019 at 16:30 | history | asked | lviz | CC BY-SA 4.0 |