php怎样获取去年日期,如何从日期范围中获取年数PHP

我有一些日期,使用日期格式的日期范围.现在,我只希望从那年起只有几年.

假设某人的日期范围为：2010年1月1日至2019年9月5日.

我希望从此日期起只有几年,所以我会将它们包括在我的sql查询中.

如果今年指定了范围,该查询仅适用于2015年,但是如何才能仅在范围内的所有年份使用该查询？

这是查询：

$sql = "SELECT

MONTH (transaction_date),

SUM(case when finance_type != 'Deposit' then amount else 0 end) AS total_amount,

SUM(case when finance_type = 'Deposit' then amount else 0 end) AS deposit,

SUM(case when finance_type != 'Deposit' AND amount < 0 then amount else 0 end) AS expenses,

SUM(case when finance_type != 'Deposit' AND amount > 0 then amount else 0 end) AS earning,

SUM(case when finance_type != 'Deposit' AND amount!='' then num_contract else 0 end) AS total_contracts,

transaction_date

FROM

`tbl_finanace`

WHERE

transaction_date LIKE '%2015%'

AND user_id = '15'

GROUP BY

MONTH (transaction_date)

ORDER BY

MONTH (transaction_date)";

解决方法:

您可以使用小于和大于的DATETIME字段.

where transaction_date <= '2010-01-01 00:00:01' and transaction_date >= '2005-12-31 23:59:59'

标签：mysql,php,date,sql-server

来源： https://codeday.me/bug/20191120/2043126.html