DAYOFWEEK_ISO
Returns the ISO 8061 day of the week as an integer, where Monday is day 1.
Behavior Type
- Immutable if the
target date is a
TIMESTAMP
,DATE
, orVARCHAR
- Stable if the target date is a
TIMESTAMPTZ
Syntax
DAYOFWEEK_ISO ( date )
Parameters
date |
The date to process, one of the following data types: |
Examples
=> SELECT DAYOFWEEK_ISO(TIMESTAMP 'Sep 22, 2011 12:34'); DAYOFWEEK_ISO --------------- 4 (1 row)
The following example shows how to combine the DAYOFWEEK_ISO, WEEK_ISO, and YEAR_ISO functions to find the ISO day of the week, week, and year:
=> SELECT DAYOFWEEK_ISO('Jan 1, 2000'), WEEK_ISO('Jan 1, 2000'),YEAR_ISO('Jan1,2000'); DAYOFWEEK_ISO | WEEK_ISO | YEAR_ISO ---------------+----------+---------- 6 | 52 | 1999 (1 row)