weired behaviour with between operator and sysdate

[AndyEPS]

Alternatively use TRUNC(SYSDATE) when you want to store todays date (without time - ie. time of 00:00:00 ) so that your insert would use trunc(sysdate).