Postgresql difference between two columns dates?

Question

Username    DateStart  DateFinish
James       2017-07-01 2017-09-14
Luigi       2017-08-02 2017-09-18
Francesco   2017-09-03 2017-10-25

How calculate with sql difference between two date columns in days?

Rahul Tripathi · Accepted Answer · 2017-10-19 09:42:46Z

6

You can simply subtract them like

select "DateFinish"::date - "DateStart"::date;

And if the dates column are of datatype date then you can simply do:

select "DateFinish" - "DateStart"

answered Oct 19, 2017 at 9:42

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

Comments

Ashkan Kazemi · Accepted Answer · 2017-10-19 10:10:29Z

2

If you want to see the difference in a number (10 instead of a date value that has 10 days in it), you can obtain it with:

select extract(day from "DateFinish" - "DateStart")

answered Oct 19, 2017 at 10:10

Ashkan Kazemi

1,12510 silver badges27 bronze badges

The extract is unnecessary

João Nunes · Accepted Answer · 2018-04-06 13:04:53Z

2

Try this. It extracts the number of days between 2 dates and creates a column called "days":

select extract(day from DateFinish - DateStart) as days from MyTable;

answered Apr 6, 2018 at 13:04

João Nunes

3,76933 silver badges33 bronze badges

The extract is unnecessary