delete from aa where type=1 and 时间>=to_date('2006-09-15 10:12:00','yyyy-mm-dd hh24:mi;ss') and 时间<=to_date(2006-10-15 10:12:00','yyyy-mm-dd hh24:mi;ss')
上面写错了 时间>=to_date('2006-09-15 10:12:00','yyyy-mm-dd hh24:mi:ss') and 时间<=to_date('2006-10-15 10:12:00','yyyy-mm-dd hh24:mi:ss')
and 时间>=to_date('2006-09-15 10:12:00','yyyy-mm-dd hh24:mi;ss')
and 时间<=to_date(2006-10-15 10:12:00','yyyy-mm-dd hh24:mi;ss')
时间>=to_date('2006-09-15 10:12:00','yyyy-mm-dd hh24:mi:ss')
and 时间<=to_date('2006-10-15 10:12:00','yyyy-mm-dd hh24:mi:ss')