time zones
1 Topic
Force world wide queries to single time zone
Hello, I hope somebody would be able to help me. We are using an Azure SQL database. When querying datetime fields, the result is adjusted for the time zone that you are in. As example, I have a column called CreationDate in table Bronze. A record is inserted in California with a system datetime of 1 July 08h00 (Pacific time). When somebody in Ireland queries the data, the value in CreationDate reflects 1 July 15h00 (Irish time). We know that we can force the time during query time (see query below), but that means that all reports need to include this logic. We would prefer if there was an Azure SQL configuration setting that will always return the same value, regardless of time zone. Could anybody tell me how we do this? Thank you - Jaunine SELECT [CreationDate] ,CONVERT(DATETIME2(0), [CreationDate], 126) AT TIME ZONE 'GMT Standard Time' AT TIME ZONE 'Pacific Standard Time' as pst_date FROM Bronze where trim([item]) = '1524200'Solved2.4KViews0likes5Comments