EXTRACTDOW

This function returns the day of the week component of the input timestamp value. Also see EXTRACT.

Syntax

EXTRACT(DOW FROM TIMESTAMP timestamp_expr)