I am trying to run the below query to select some results between 2 dates but I am getting results as the condition doesn’t exist. So what is wrong here? Answer You are comparing dates with strings; the dates are converted to strings to do that comparison. From the documentation: During SELECT FROM operations, Oracle converts the data from the