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

MySQL Date Time: Exercise-4 with Solution

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

Code:

-- This SQL query creates a date using the year extracted from the current date and the day '1'.

SELECT 
MAKEDATE( -- Creates a date using the specified year and day.
EXTRACT(YEAR FROM CURDATE()), -- Extracts the year from the current date (CURDATE()).
        1 -- Specifies the day as '1'.
    );

Explanation:

• The EXTRACT(YEAR FROM CURDATE()) function extracts the year from the current date using the CURDATE() function.
• The MAKEDATE() function then takes the extracted year and the day '1' to create a date value.
• This effectively creates a date for the first day of the current year.

Sample Output:

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

Go to:

• MySQL Date and Time Exercises Home. ↩
• MySQL Exercises Home ↩

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

MySQL Code Editor:

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