'DAYOFWEEK function for SEDE?

The specifications on SQL Azure mention ODBC date and time functions, namely to transform a date to weekday.

Currently, using DAYOFWEEK results in an error message:

SELECT DAYOFWEEK(LastActivityDate) FROM Posts Limit 1;

Error: 'DAYOFWEEK' is not a recognized built-in function name.

sqltsqlazureodata


Solution 1:[1]

I followed the link to the documentation that you gave, and they illustrate the usage as:

SELECT TOP 1
    {fn DAYOFWEEK( LastActivityDate )}
FROM Posts

Example: https://data.stackexchange.com/stackoverflow/query/716136

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 CÅ“ur

Related Questions