invalid type for EXTRACT JULIAN - must be DATE or TIMESTAMP

  Explanation:  The EXTRACT JULIAN 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.