java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号

Question

select * from (

select a.*, ROWNUM rnum from (

select * from SHOP_ORDER
WHERE start_date between to_date(‘2016-08-22 11:34:36’,'yyyy/mm/dd hh24:mi:ss')

and close_date between to_date('2016-09-22 11:34:36','yyyy/mm/dd hh24:mi:ss') ) a where ROWNUM< ?) where rnum >= ?

求各位大神大牛帮帮小弟！！！！

Answer 1

‘2016-08-22 11:34:36’ 此处标点符号打错了。用的中文的
后一个between没有and