sql-server

UTC to UAE Time (Arabian Standard Time)

Convert UTC time to Arabian Standard Time in SQL Server

Abhith Rajan
Abhith RajanSeptember 07, 2021 · 1 min read · Last Updated:
1SELECT CONVERT(datetime, SWITCHOFFSET(GETUTCDATE(), DATEPART(TZOFFSET,
2GETUTCDATE() AT TIME ZONE 'Arabian Standard Time'))) AS CreationTime

Replace GETUTCDATE() with your table column that has the UTC time.

Written by Abhith Rajan
Abhith Rajan is an aspiring software engineer with more than nine years of experience and has a proven successful track record of delivering technology-based products and services.
Buy me a coffee

This page is open source. Noticed a typo? Or something unclear?
Improve this page on GitHub

Related ArticlesView All

Related VideosView All

SQL Server 2017 Graph Database

Azure SQL Game Changers for Developers | BDL112

Related StoriesView All

Related Tools & ServicesView All

sqlfum.pt

sequel fumpt

sqlfmt is an online SQL formatter. It is pronounced sequel fumpt. Its purpose is to beautifully format SQL statements.
SmarterASP.NET

SmarterASP.net - Unlimited ASP.NET Web Hosting

ASP.NET Hosting by SmarterASP.net. Unlimited ASP.NET Hosting Plans Starting at $2.95 a month.