SELECT
*
FROM
JK_APPRAISE_DETAIL
WHERE
CREATE_DATE BETWEEN to_char( SYSDATE - 31, 'yyyy-mm-dd hh24:mi:ss' )
AND to_char( SYSDATE, 'yyyy-mm-dd hh24:mi:ss' )
AND cus_id = '81b7d5ee0ef24b8e8984f5cb875054ec'
AND assess_Guage_Name = '中医自测'
SELECT
*
FROM
JK_APPRAISE_DETAIL
WHERE
CREATE_DATE BETWEEN SYSDATE - 7
AND SYSDATE
AND cus_id = '81b7d5ee0ef24b8e8984f5cb875054ec'
AND assess_Guage_Name = '中医自测'
java代码使用${}
List<JkAppraiseDetail> getTraditional(@Param("patientId") String patientId, @Param("identification") String identification);
SELECT
*
FROM
JK_APPRAISE_DETAIL
WHERE
CREATE_DATE BETWEEN SYSDATE - ${identification}
AND SYSDATE
AND cus_id = #{patientId}
AND assess_Guage_Name = '中医自测'
这辈子坚持与不坚持都不可怕,怕的是独自走在坚持的道路上!!!