SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0); -- SQL Server SELECT TRUNC(sysdate, 'YEAR') FROM DUAL; -- Oracle SELECT MAKEDATE(year(now()), 1); -- MySQL
-- Replace curdate() with your date column SELECT curdate(), DATE_SUB( curdate(), INTERVAL DAYOFMONTH(curdate())-1 DAY ) AS '1st of month';