Progress
SQL-92
Guide and Reference


DAYNAME Function

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.

SYNTAX

DAYNAME ( date_expression ) 

EXAMPLE

This example illustrates the DAYNAME function:

SELECT *
     FROM orders
     WHERE order_no = 342 and DAYNAME(order_date)=’SATURDAY’;
 
 
ORDER_NO  ORDER_DATE  REFERENCE         CUST_NO
-------- -----------  ----------        --------
342       08/10       tdfg/101          10001
 
1 record selected 

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095