PostgreSQL的两列日期之间的区别？ [英] Postgresql difference between two columns dates?

问题描述

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

如何用天中两个日期列之间的sql差计算？

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

推荐答案

您可以简单地将它们减去

You can simply subtract them like

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

如果dates列的数据类型为date，那么您只需执行以下操作：

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

select "DateFinish" - "DateStart"

这篇关于PostgreSQL的两列日期之间的区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！