ORACLE 日期字段类型为2023-03-15 15:31:23.000000 想跟报表里的参数绑定,参数格式如图:我该如何用where语句限定
where to_char(zd,"yyyy-MM")='${rq}'
oracle 日期字段to_char(字段,"yyyy-MM-dd"),转换为字符串
-------------------------
${if(len(begintime)==0,""," and to_char(字段,"yyyy-MM-dd")>='"+begintime+"'")}
${if(len(endtime)==0,""," and to_char(字段,"yyyy-MM-dd")<='"+endtime+"'")}
where TO_CHAR(your_date_column, 'YYYY-MM') ='${cs}'