ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Query to Change Time Zone in SQL Server<p>Hi&nbsp;iammann,</p> <p>Refer below links.</p> <p><a href="https://www.c-sharpcorner.com/UploadFile/919746/convert-local-time-from-other-time-zones-in-sql-server/">https://www.c-sharpcorner.com/UploadFile/919746/convert-local-time-from-other-time-zones-in-sql-server/</a></p> <p><a href="https://stackoverflow.com/questions/24797/effectively-converting-dates-between-utc-and-local-ie-pst-time-in-sql-2005">https://stackoverflow.com/questions/24797/effectively-converting-dates-between-utc-and-local-ie-pst-time-in-sql-2005</a></p> <p><a href="https://github.com/mj1856/SqlServerTimeZoneSupport">https://github.com/mj1856/SqlServerTimeZoneSupport</a></p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/122671/Query-to-Change-Time-Zone-in-SQL-Server/https://www.aspforums.net:443/Threads/122671/Query-to-Change-Time-Zone-in-SQL-Server/Mon, 05 Nov 2018 05:48:46 GMTQuery to Change Time Zone in SQL Server<p>Thanks for your reply</p> <pre class="brush: sql">select CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GetUTCDate()),&#39;+05:30&#39;)) Date_India</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/122671/Query-to-Change-Time-Zone-in-SQL-Server/https://www.aspforums.net:443/Threads/122671/Query-to-Change-Time-Zone-in-SQL-Server/Sat, 10 Nov 2018 03:43:02 GMT