跟字符集有关系
还是这样保险一些
and a.test_date between to_date('2004-10-06 01:00:00','yyyy-mm-dd HH24:MI:SS')
and to_date('2004-10-22 01:00:00','yyyy-mm-dd HH24:MI:SS')
还是这样保险一些
and a.test_date between to_date('2004-10-06 01:00:00','yyyy-mm-dd HH24:MI:SS')
and to_date('2004-10-22 01:00:00','yyyy-mm-dd HH24:MI:SS')
select a.*,b.* from mat_assembly_header a ,mat_assembly_data b
where a.header_id=b.header_id(+)
and a.ser_part_id like '60%'
and to_char('2004-10-22 01:00:00','yyyy-mm-dd HH24:MI:SS')
in ('06 Oct 2004 01:00:00','22 Oct 2004 01:00:00' )
Oct就比Nov大