invalid type for EXTRACT WEEKDAY - must be DATE or TIMESTAMP

  Explanation:  The EXTRACT WEEKDAY requires that  the  result  of
  the value expression be a DATE or a TIMESTAMP.

  User Action:  Correct the query to use a  valid  data  type  for
  EXTRACT.