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:
2GETUTCDATE() AT TIME ZONE 'Arabian Standard Time'))) AS CreationTime

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

Abhith Rajan

Written byAbhith 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.

Is this page helpful?

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 Tools & ServicesView All


sequel fumpt

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

SmarterASP.net - Unlimited ASP.NET Web Hosting

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