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

3 votes125 views1 answer
Mssql remove column
SQL
-1 vote135 views2 answers
First letter capital in mysql query
SQL
4 votes118 views4 answers
Rollback in sql
SQL
-1 vote146 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote120 views1 answer
Mysql update sequence with order by
SQL
0 vote137 views1 answer
Mysql set boolean default value
SQL
0 vote142 views1 answer
Shows all databases created by user in ms sql
SQL
7 votes123 views6 answers
Group_concat mysql
SQL
9 votes125 views4 answers
Add primary key to existing table sql
SQL
1 vote130 views1 answer
Mysql view command
SQL