4.9.2.23 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