mysql 日期_习惯累积沉淀_新浪博客

select count(*) from imrd_cnxau9999rt where 

time >= to_timestamp('2014-11-06', 'yyyy-mm-dd')

and time < to_timestamp('2014-11-16', 'yyyy-mm-dd');

select max(id) from imrd_cnxau9999rt;

select max(time) from imrd_cnxau9999rt;              //对time没用

select time from imrd_cnxau9999rt order by time desc

10-11月-14 09.01.05.608000000 上午