Query to Change Time Zone in SQL Server

Last Reply 10 days ago By iammann

Posted 15 days 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 10 days ago

Thanks for your reply

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