Character expression is evaluated from left to right by each character so your result is correct. You should change where clause if you want to compare date part separately.