|
|
|
DAYNAME function (ODBC compatible)
Syntax
DAYNAME ( date_expression )
Description
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 *
FROM orders
WHERE order_no = 342 and DAYNAME(order_date)='SATURDAY';
ORDER_NO ORDER_DATE REFERENCE CUST_NO
342 08/10/1991 tdfg/101 10001
1 record selected
