MySQL Date and Time Exercises: Get the first day of the current year

MySQL Date Time: Exercise-4 with Solution

Write a query to get the first day of the current year.

Code:

SELECT MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1);

Sample Output:

MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1)
2017-01-01T05:00:00.000Z

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the distinct Mondays from hire_date in employees tables.
Next:Write a query to get the last day of the current year.