select count(phonenumber) from t_hispersonaldownreport where phonenumber like'029%' and operatetype='0' and ='0' and time_id=to_date('20051021', 'YYYYMMDD')
select count(phonenumber) from t_hispersonaldownreport group by phonenumber like'029%' having operatetype='0' and ='0' and time_id=to_char('2005-10-21', 'YYYY-MM-DD')
如果只是查询的话,可以先修改session的时间格式:alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS' 转换一下日期格式; 或者在系统环境变量里增加一个变量nls_date_format值可以为yyyy-mm-dd,值也可以选择你需要的日期格式;
接分 ^^ select count(phonenumber) from t_hispersonaldownreport where phonenumber like'029%' and operatetype='0' and ='0' and to_char(time_id,'yyyy-mm-dd')='2005-10-21'
看来我得好好学学oracle了!
如果用between'2005-10-21' and'2005-11-20'时,也要像上面一样转化时间吗?
还是另有语句?sysdate可以吗?
或者在系统环境变量里增加一个变量nls_date_format值可以为yyyy-mm-dd,值也可以选择你需要的日期格式;
select count(phonenumber) from t_hispersonaldownreport where phonenumber like'029%' and operatetype='0' and ='0'
and to_char(time_id,'yyyy-mm-dd')='2005-10-21'