Query to Change Time Zone in SQL Server

Last Reply one year ago By iammann

Posted one year 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 one year ago

Thanks for your reply

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