In FedSQL, the function DATEPART() is not valid, which is why you are getting a syntax error. If your column REPONSE_DATE is already stored as a DATE, you can directly compare it using WHERE t1.REPONSE_DATE = DATE '2025-07-15'. If it is a DATETIME, you should first cast it to a DATE and then compare, for example WHERE CAST(t1.REPONSE_DATE AS DATE) = DATE '2025-07-15'. This will fix your error and run correctly.
... View more
