Using QlikView on ODBC to a Progress database I can use functions like YEAR(), MONTH() and WEEK() to get the year, month and week number from a date field.
To get the day of the week in ABL I use the function WEEKDAY().
This function is not working in a SQL select statement.
What function could I use in SQL to get the day of the week number from a date?
Kind regards,
Peter Wokke
DAYOFWEEK ( date_expression )
Returns the day of the week in the argument as a short integer value in the range of 1-7.
The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.
Example:
SELECT DAYOFWEEK('3/10/2016') FROM PUB.CUSTOMER;
dayofweek(3/10/2016)
--------------------
5
DAYNAME ( date_expression )
Returns a character string containing the name of the day (for example, Sunday through Saturday)
for the day portion of date_expression. The argument date_expression can be the name
of a column, the result of another scalar function, or a date or timestamp literal.
Example:
SELECT DAYNAME('3/10/2016') FROM PUB.CUSTOMER;
dayname(3/10/2016)
------------------
THURSDAYHi Dileep,
Thank you kindly for the examples of both functions.
It helped me well building my QlikView data analyze.
Kind regards,
Peter