how to obtain interval from date on postgres in days

Question

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.

Did you read the manual before asking. This is all explained there: postgresql.org/docs/current/static/functions-datetime.html — user330315
– user330315, Commented Sep 15, 2012 at 17:37

rationalboss · Accepted Answer · 2012-09-15 17:29:37Z

5

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

answered Sep 15, 2012 at 17:29

rationalboss

5,3973 gold badges32 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

how to obtain interval from date on postgres in days

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related