how to query utcdate in mssql to local date code example
Example: tsql utf to local time
select
[MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]
select
[MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]