CakeDC/utils

Publishable, field_date condition in query

Closed this issue · 1 comments

line 203
['field_date'] . ' <='] = date('Y-m-d H:i');

to

['field_date'] . ' <='] = date('Y-m-d H:i:s');

Sorry, i can't pull a request , it keep show a 404 page.

This problem cause confuse for everyone

Using H:s will allow the database engine to cache the query for around 1 minute and should not make much difference to users.

Changing to H:i:s will mean there is no chance of cache as the query would be different every second.

How exactly is this confusing everyone?