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 vote105 views1 answer
Insufficient memory to excute the sql query
SQL
2 votes108 views2 answers
Set database timezone mysql
SQL
1 vote112 views1 answer
Altering the column name in MySQL to have a default value
SQL
-1 vote127 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote123 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote97 views2 answers
How to start postgresql laravel
SQL
0 vote113 views2 answers
Temp Space
SQL
1 vote111 views1 answer
Access the postgres psql
SQL
0 vote113 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote95 views1 answer
Call procedure in wordpress
SQL