"how to change the timezone in azure sql database?" Code Answer

from msdn: use at time zone

select convert(datetime, '03/29/2015 01:01:00')   
at time zone 'central european standard time';  
--2015-03-29 01:01:00.000 +01:00  

--time between 02:00 and 03:00 is converted as +01!  
select convert(datetime, '03/29/2015 02:01:00')   
at time zone 'central european standard time';  
--2015-03-29 02:01:00.000 +01:00  

select convert(datetime, '03/29/2015 03:01:00')   
at time zone 'central european standard time';  
--2015-03-29 03:01:00.000 +02:00

By Andy Finkenstadt on April 13 2022