DAYOFWEEK

Returns the day of the week as an integer, where Sunday is day 1.

Behavior type

• Immutable if thetarget date is a TIMESTAMP, DATE, or VARCHAR

• Stable if the target date is aTIMESTAMPTZ

Syntax

DAYOFWEEK ( date )

Parameters

date

The date to process, one of the following data types:

• VARCHAR
• DATE
• TIMESTAMP
• TIMESTAMPTZ

Examples

=> SELECT DAYOFWEEK (TIMESTAMP 'sep 17, 2011 12:34');
 DAYOFWEEK
-----------
         7
(1 row)