DAYNAME function [Date and time]

Function

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

Syntax

DAYNAME ( date-expression )

Parameters

date-expression The date.

Example

The following statement returns the value Saturday:

SELECT DAYNAME ( '1987/05/02' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Not supported by Adaptive Server Enterprise