How to get difference between 2 dates in PostgreSQL with TIMESTAMPDIFF? [duplicate]

Question

I'm trying to get it as:

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

but I get the next error:

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.

I've found another way to get difference between 2 dates but in my instructions it says that I have to get it via TIMESTAMPDIFF. Can someone help me where to look and how to fix my error?

"HireDate" - "BirthDate" There is no timestampdiff in Postgres - whatever those instructions are, they are clearly for a different DBMS product. postgresql.org/docs/current/static/functions-datetime.html — user330315
– user330315, Commented Oct 21, 2018 at 17:34
@a_horse_with_no_name you mean to switch places? I've tried it also and I got the same error — J. Doe
– J. Doe, Commented Oct 21, 2018 at 17:35

Zaynul Abadin Tuhin · Accepted Answer · 2018-10-21 17:41:15Z

3

you can use minus operator

EXTRACT(DAY FROM (HireDate)-(BirthDate)) AS DateDifference

Example select date '2001-10-01' - date '2001-09-28'

DEMO IN FIDDLE

PostGrey Docs

edited Oct 21, 2018 at 17:41

answered Oct 21, 2018 at 17:35

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gordon Linoff Over a year ago

Interesting. This works with -, but it doesn't work with age().

Vishantha Peiris Over a year ago

with age , date_part('year', age("BirthDate", "HireDate"))

J. Doe Over a year ago

so how I understood there is no TIMESTAMPDIFF in PostgreSQL, right? By the way, thanks for the answer!

Collectives™ on Stack Overflow

How to get difference between 2 dates in PostgreSQL with TIMESTAMPDIFF? [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related