CODEWITHSUNDEEP
phpmysql
KeepCool
KeepCool

Reputation: 565

Select Distinct records from a Timestamp row using day only from MySQL table

I'm trying to query only distinct dates from my table (ignoring the times) which uses timestamp for the date format (should I use a better format?). Here is my query, but it doesn't seem to work:

$query = "
    SELECT DISTINCT DATE(event_date)
    FROM schedule
    WHERE DATE(event_date) >= CURDATE()
    ORDER BY event_date ASC LIMIT 4
";

"event_date" is my timestamp row in the database.

Upvotes: 0

Views: 235

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269693

You may have a problem with the order by. How about this?

SELECT DATE(event_date)
FROM schedule
WHERE event_date >= CURDATE()
GROUP BY DATE(event_date)
ORDER BY DATE(event_date) ASC
LIMIT 4;

Upvotes: 1

Related Questions