Simple life, Complicated mind: MySQL - get the first day of the current quarter

Tuesday, July 21, 2015

SELECT MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL (QUARTER(CURDATE()) - 1) QUARTER