postgresql 月份

作者: 黄寒辞
来源: 51数据库
2020-09-30

--?使用?age?函数.?返回2个日期直接的间隔，?生成一个使用年、月的"符号化"的结果
Test=#?SELECT?age('2013-04-01',?timestamp?'2010-01-01');
??????age
----------------
?3?years?3?mons
(1?行记录)

--?取得具体的?int?数字
Test=#?SELECT
Test-#???EXTRACT(YEAR?from?age('2013-04-01',?timestamp?'2010-01-01')),
Test-#???EXTRACT(MONTH?from?age('2013-04-01',?timestamp?'2010-01-01')),
Test-#???EXTRACT(DAY?from?age('2013-04-01',?timestamp?'2010-01-01'));
?date_part?|?date_part?|?date_part
-----------+-----------+-----------
?????????3?|?????????3?|?????????0
(1?行记录)

推荐阅读