DAYNAME Function [Date and Time]

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

Syntax

DAYNAME ( date-expression )

Parameters

Parameters

Parameter

Description

date-expression

The date.

Returns

VARCHAR

Example

The following statement returns the value Saturday:

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

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions