trans_time between
to_date('2008-11-01', 'yyyy-MM-dd') and
to_date('2008-11-30', 'yyyy-MM-dd')
如果有分秒,[color=red]不是HH:mm:ss[/color]
trans_time between
to_date('2009-03-18 000000', 'yyyy'yyyy-MM-dd HH24MISS') and
to_date('2009-03-19 235959', 'yyyy-MM-dd HH24MISS')