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.
Hi iammann,
Refer below links.
https://www.c-sharpcorner.com/UploadFile/919746/convert-local-time-from-other-time-zones-in-sql-server/
https://stackoverflow.com/questions/24797/effectively-converting-dates-between-utc-and-local-ie-pst-time-in-sql-2005
https://github.com/mj1856/SqlServerTimeZoneSupport
Thanks for your reply
select CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GetUTCDate()),'+05:30')) Date_India
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.