you should use to_date when dealing with date because otherwise you will end up things working in one place but not working in others because of NLS settings