JZTXT

人大金仓数据库 日期计算

发布时间 2023-12-09 12:36:45作者: ジ绯色月下ぎ
-- 减法
select date_format(now() -  '1 HOUR'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '1 DAY'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '1 WEEK'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '1 MONTH'::interval , '%Y-%m-%d %h' );
select date_format(now() -  '1 YEAR'::interval , '%Y-%m-%d %H' );
-- 加法
select date_format(now() -  '-1 HOUR'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '-1 DAY'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '-1 WEEK'::interval , '%Y-%m-%d %H' );
select date_format(now() -  '-1 MONTH'::interval , '%Y-%m-%d %h' );
select date_format(now() -  '-1 YEAR'::interval , '%Y-%m-%d %H' );