Tuesday, July 21, 2015

MySQL - get the first day of the current quarter

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

No comments: