Change Default Time Zone From UTC to CST in Azure Syanspe & Data Lake

Question

I want to change the time zone of Azure Data Lake and Synapse from UTC to CST. Because I have some source systems on my on-premise like (Oracle, SQL) and they have time stamp of CST but when I ingest that into Azure Data Lake and read it from Synapse it shows me the times stamp of UTC. Is their any why to change or convert the timestamp.

Thanks in advance

Answer 1

Hi @Abdul Rahim Amjad ,

Thanks for using Microsoft Q&A !!

You cannot unfortunately change the default time zone of at server level and so you need to modify existing data queries to use AT TIME ZONE while reading the data.
Please refer to the example which converts time between two different time zones where PST is being considered as a known time zone offset of OrderDate column and converted to CET timezone using AT TIMEZONE clause.

SELECT SalesOrderID, OrderDate,  
    --Assign the known offset, then convert to another time zone  
    OrderDate AT TIME ZONE 'Pacific Standard Time' AT TIME ZONE 'Central European Standard Time' AS OrderDate_TimeZoneCET  
FROM Sales.SalesOrderHeader;  

Also, in storing data in a non-UTC time zone is not a best practice in my opinion.

You could provide your feedback at Synapse Uservoice.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.