The return format is not how it is stored in the DB.
Are you using a date field or a date/time field?
this in your OP indicated to me that you are using a date field $today = date('Ymd');
.
But the format on your last posts indicates a date/time field.
Which is it?