Find datetimes with time of 00:00:00
Date: 09/09/08
(MySQL Communtiy) Keywords: no keywords
What is the best/fastest way to find records with datetimes having times of 00:00:00? ex: `2008-01-23 00:00:00`
Using LIKE '%00:00:00' takes a relatively long time (2 seconds looking across 500,000 records).
Source: https://mysql.livejournal.com/131436.html
|