Query to Change Time Zone in SQL Server

Last Reply 8 months ago By iammann

Posted 8 months ago

I am using a server in which default time zone is of arizona .but when i talked to customer support then they told me that it cant not change on indian time zone..or asia pacific ..so please give me any alternate solution to resolve this issue.


Posted 8 months ago

Thanks for your reply

select CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GetUTCDate()),'+05:30')) Date_India