The reason is because the time for table object in console by default is local. But when you search with query created < DATE, it compares your date with server UTC time.
In your case, you have a record, that is created on the 23th, but your local time is still 22th.
If you use a query in console that compares dates, please select the checkbox “Dates in UTC”. It will show UTC time instead of local.