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 vote368 views1 answer
Postgres regex word boundary
SQL
0 vote338 views1 answer
Oracle drop default value
SQL
1 vote330 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote371 views1 answer
Sqlite woth cmake
SQL
0 vote333 views1 answer
Sql string length postgresql
SQL
5 votes352 views1 answer
How to get all dates in a month in oracle
SQL
0 vote368 views1 answer
Postegresql update to null
SQL
1 vote386 views1 answer
Tsql replace value in json
SQL
0 vote348 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote353 views1 answer
Sql server create constraint
SQL