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 vote205 views1 answer
How to update sql server version
SQL
1 vote208 views1 answer
Mysql text to decimal
SQL
-1 vote205 views3 answers
Error mysql shutdown unexpectedly
SQL
8 votes193 views2 answers
Select table column name in sql
SQL
1 vote229 views1 answer
Sql server set variable if exists
SQL
-1 vote196 views1 answer
Sql add column bit
SQL
0 vote186 views1 answer
Deny select insert update delete sql
SQL
0 vote208 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote233 views3 answers
How to update column name in psql
SQL