invalid type for EXTRACT LENGTH - must be CHAR or VARCHAR

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

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