select count(*) from couponreceiverecord where RECEVETIME>=to_date('2012-12-17 16:00:00','yyyy-MM-dd HH24:mi:ss') and RECEVETIME<=to_date('2012-12-17 17:00:00','yyyy-MM-dd HH24:mi:ss')
Oracle时间不同于SQL,转换时要注意几点:
1、转换时要用to_date;
2、转成24进制的时间时要用HH24;
3、分钟要用mi;