mysql根据时间获取去年时间

最新推荐文章于 2024-06-30 13:18:55 发布

南大白

最新推荐文章于 2024-06-30 13:18:55 发布

阅读量110

点赞数 1

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_39069718/article/details/139797441

版权

SELECT DATE_FORMAT(DATE_SUB('2023-03-15', INTERVAL 1 YEAR), '%Y-%m-%d') AS last_year_date;

列子

SELECT
	today.tjrq,
	today.dwmc,
	today.brye / 10000 AS brye,
	today.brxz,
	(today.current_balance - yesterday.current_balance) 	AS tongbi,
	today.brye / 82 / 10000 AS brdj,
	today.byxz,
	today.bjxz,
	today.bjxztbzl,
	today.bnxz,
	today.bnxztbzl,
	today.bnzf,
	today.bnzfmc 
FROM
	 (SELECT ttt.*,brxz as current_balance FROM ydyy_ye_pq ttt WHERE ttt.tjrq =  date_format('${p_riqi}','%Y%m%d')	AND ttt.dwmc = '北京市')  AS today
	JOIN
  (SELECT brxz as current_balance FROM ydyy_ye_pq WHERE dwmc = '北京市' and tjrq=	(SELECT DATE_FORMAT(DATE_SUB(date_format('${p_riqi}','%Y%m%d'), INTERVAL 1 YEAR), '%Y%m%d') ))  AS yesterday