在求和中用 MONTH_xdrq 按月查询不生效
迅睿框架 更新 2022-04-08 21:23:01
心如意
心如意
时间范围
请问在求和中用 MONTH_xdrq 按月查询不生效
{sum sum=jiner action=module module=news gysid=1 MONTH_xdsj=2022-2}
写了个sql，日期范围报错了，请问下面的sql语句要怎样修改？
{sum sum=jiner action=sql sql='select jiner from dr_1_news where gysid=1 DATE_FORMAT(FROM_UNIXTIME(xdsj),'%Y-%m')="2022-1"'}谢谢
{php $sql=urlencdoe('select jiner from dr_1_news where gysid=1 DATE_FORMAT(FROM_UNIXTIME(xdsj),'%Y-%m')="2022-1"');} {sum sum=jiner action=sql sql='$sql'}{php $sql=urlencode('select jiner from dr_1_news where gysid=1 and DATE_FORMAT(FROM_UNIXTIME(xdsj),\'%Y-%m\')="2022-1"');}😅 ，满意的话打赏几块钱吧