Format any date into current year's date (to account for Leap Years) - Cacher Snippet

10/22/2018 - 9:07 PM

Format any date into current year's date (to account for Leap Years)

Format any date into current year's date (to account for Leap Years)

MySQL Set date to current year.sql

set @currentdate = '2018-01-01';
SELECT
DATE_FORMAT(DATE_ADD(date_column,INTERVAL (YEAR(CURDATE()) - YEAR(date_column)) YEAR), '%Y-%m-%d') AS `date`
FROM table_name;