DOW function [Date and time]

Function

Returns a number from 1 to 7 representing the day of the week of the specified date, with Sunday=1, Monday=2, and so on.

Syntax

DOW ( date-expression )

Parameters

date-expression The date.

Example

The following statement returns the value 5:

SELECT DOW( '1998-07-09' ) FROM iq_dummy

Usage

See DATE_FIRST_DAY_OF_WEEK option in Reference: Statements and Options if you need Monday (or another day) to be the first day of the week.

Standards and compatibility

SQL92 Vendor extension

Sybase Not supported by Adaptive Server Enterprise