Mysql first day of year

SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0);			-- SQL Server
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;					-- Oracle
SELECT MAKEDATE(year(now()), 1);							-- MySQL

Mysql first day of month

-- Replace curdate() with your date column
SELECT curdate(), 
	DATE_SUB( curdate(), INTERVAL DAYOFMONTH(curdate())-1 DAY ) AS '1st of month';

Source: oreilly.com

Mysql first day of year

SELECT 
	* 
FROM `users` 
WHERE YEAR(created_at) = YEAR(now())

Source: nicesnippets.com

Similar codes

0 vote183 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes177 views1 answer
Mysql clear screen
SQL
0 vote185 views2 answers
Advantages of stored procedures sql
SQL
0 vote193 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote180 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
3 votes218 views1 answer
Laravel paginate raw sql
SQL
3 votes151 views4 answers
Show columns from table
SQL
11 votes188 views2 answers
Having in sql
SQL
10 votes194 views2 answers
Mysql drop database if exists
SQL
10 votes190 views4 answers
Join with multiple conditions sql
SQL