ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Query to Change Time Zone in SQL Server<p>Hi&nbsp;iammann,</p> <p>Refer below links.</p> <p><a href=""></a></p> <p><a href=""></a></p> <p><a href=""></a></p> <p>&nbsp;</p>, 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>, 10 Nov 2018 03:43:02 GMT