I have a .net application running on a Azure server which is set to PST and it connects to a Azure SQL server set to UTC time. I use the function getDate() in a lot of my stored procedures. Going forward time zone is going to be a critical issue and need to have them both in sync. Using the function DateAdd(hour, -8, getDate()) does not account for daylight savings time. I was wondering if there was a better way to handle this.
1 Answers
Related