如何用TIMESTAMPDIFF获得PostgreSQL中两个日期之间的差异[[副本]

SELECT * FROM "Employee" WHERE TIMESTAMPDIFF('YEAR', "BirthDate", "HireDate");

但我得到了下一个错误:

ERROR:  function timestampdiff(unknown, timestamp without time zone, timestamp without time zone) does not exist
LINE 1: SELECT * FROM "Employee" WHERE TIMESTAMPDIFF('YEAR', "BirthD...
                                   ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

我找到了另一种方法来区分两次约会,但在我的说明中说我必须通过 TIMESTAMPDIFF 有人能帮我去哪里找,怎么改正我的错误吗?