UTC to UAE Time (Arabian Standard Time)

Convert UTC time to Arabian Standard Time in SQL Server

Follow @FrainlarEdsonEdson FrainlarSeptember 07, 2021 · 1 min read · Last Updated: September 07, 2021

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.

sql-server

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

Written byEdson Frainlar Follow @FrainlarEdson
Mission-driven Full-stack Developer with a passion for developing KTern, Dev Collaboration, and teaching. Curious to explore Quantum Information and Computing.
Connect

Is this page helpful?

Buy me a coffee ☕

Related StoriesView All

New and Enhanced Features in SQL Server 2022
mssqltips.com · Oct 28, 2022

Learn about some of the new features and enhancements in SQL Server 2022 and things you should consider adopting when moving to SQL Server 2022.

sql-server

Azure SQL Database now supports powerful geo-replication features for all service tiers | Azure Blog and Updates | Microsoft Azure
azure.microsoft.com · Jul 03, 2022

azure sql-server

JSON in SQL Server: The Ultimate Guide
databasestar.com · Oct 24, 2021

JSON is a popular format for storing data. Learn how to store JSON in SQL Server and how to use related functions in this guide.

sql-server

UNION And UNION ALL SQL Operators
c-sharpcorner.com · Jul 05, 2022

The primary difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set, but union all returns all rows after.

sql-server

SQL Server Profiler Extension for Azure Data Studio
mssqltips.com · Dec 26, 2021

Learn how to install and use the SQL Server Profiler extension for Azure Data Studio to use against on-premises and cloud databases.

sql-server ide

SQL Concatenation for comma seperated list using XML PATH() without COALESCE
kodyaz.com · Oct 24, 2021

Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE

sql-server