Is the 'tzoffset' function no longer compatible within Synapse?

Anon101 51 Reputation points
2024-04-17T14:25:00.3+00:00

Up until last night, executing the below script worked within our Synapse instance. However, since last night when I attempt execute the below script I receive the error message underneath.
Is the 'tzoffset' function no longer compatible within Synapse? No changes have been made to our Synapse instance in recent times. Thanks.

SELECT DATEPART(tzoffset, SYSDATETIMEOFFSET())

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,997 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,116 Reputation points Microsoft Employee
    2024-04-25T15:41:30.93+00:00

    Issue:

    • 'tzoffset' function is no longer compatible within Synapse

    error message:

    User's image

    Solution:

    The issue occurred because Microsoft deployed a new version of code that caused the error. Microsoft has since reverted the changes, and the functionality is now working as expected.

    Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.