CODEWITHSUNDEEP
postgresqldateintervals
Oeufcoque Penteano
Oeufcoque Penteano

Reputation: 603

how to obtain interval from date on postgres in days

I have two columns, say "2010-10-26" and "2010-08-23" and I would like to obtain the interval in days, what is the best way to do this on a select query taking into account that there are months with 30,31,29,28 days? Is there any function that already does this?

Thank you.

Upvotes: 2

Views: 1824

Answers (1)

rationalboss
rationalboss

Reputation: 5389

If they are already in the date format, it's very easy:

SELECT '10/26/2010'::date - '08/23/2010'::date;

OR:

SELECT date '2001-10-01' - date '2001-09-28'; // outputs integer 3

Upvotes: 5

Related Questions