How to select special date records in MySQL query

Question

I'm already using a query like below to select records on a special date since I'm storing a sort of date on my table:

... WHERE YEAR(date) = YEAR((SELECT MAX(date) FROM tblname)) AND
          MONTH(date) = MONTH((SELECT MAX(date) FROM tblname)) AND
          DAY(date) = DAY((SELECT MAX(date) FROM tblname)) ...

but I'm looking for a more simple way to doing this.

What SQL query should I use instead?

Saharsh Shah · Accepted Answer · 2014-12-03 07:17:58Z

1

Try this:

... WHERE DATE(date) = DATE(SELECT MAX(date) FROM tblname)) ...

answered Dec 3, 2014 at 7:17

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to select special date records in MySQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related