Mike Valentino Mike Valentino - 4 months ago 13
MySQL Question

Get full date of the Monday of the current week in SQL?

I have looked all over the internet and have found what I believe is outdated ways to go about this. I have the latest version of SQL and I just want to know how to get the date of the Monday of the current week via query.

Answer

I think the simplest way is weekday():

select curdate() - interval weekday(curdate()) day;

Here is a SQL Fiddle.