第一种情况,expEndTime为日期类型,转换为字符类型: select count(*) from DCDS_UPLOAD_LOG where 1 = 1 and to_char(expEndTime,'yyyy-mm-dd') = '2017-12-28' 第二种情况,expEndTime为日期类型,将转换过来的参数改为日期类型: select count(*) from DCDS_UPLOAD_LOG where 1 = 1 and expEndTime = to_date('2017-12-28', 'yyyy-MM-dd') |
|