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 vote308 views1 answer
Oracle winter time change
SQL
0 vote293 views1 answer
Nodejs sql get one to many relationship as array
SQL
-1 vote260 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
2 votes267 views1 answer
Mysql find tables with name
SQL
0 vote288 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote301 views1 answer
Set id count mysql
SQL
19 votes276 views5 answers
Change column name mysql command line
SQL
0 vote303 views1 answer
Amount of entries in a table psql
SQL
5 votes238 views1 answer
Postgres upsert
SQL
2 votes281 views2 answers
Postgres drop column if exists
SQL