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
MySQL Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: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.
What is the difficulty level of this exercise?
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/mysql-exercises/date-time-exercises/write-a-query-to-get-the-first-day-of-the-current-year.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics