My understanding of SQL is that is the same as But I’m getting completely different ResultSets when the only difference in the queries is the date range specification. The correct dates are being returned but the data is different. This is happening in both Teradata and HANA. Am I missing something? EDIT: AS POINTED OUT THIS IS THE RESULT OF