invalid option for EXTRACT - source must be a datetime type

  Explanation:  The EXTRACT option requires that the result of the
  value expression be a datetime type.

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