Query to Change Time Zone in SQL Server

Last Reply 10 months ago By iammann

Posted 10 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 10 months ago

Thanks for your reply

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