ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DAYNAME function [Date and time]

Function 

Returns the name of the day of the week from the a date.

Syntax 

DAYNAME( date-expression )

Parameters 

date-expression    The date.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns the value Saturday.

SELECT DAYNAME ( '1987/05/02' )