Mysql first day of month

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

Similar codes

0 vote121 views1 answer
Opensuse start MySQL
SQL
0 vote119 views1 answer
Mysql join same table multiple times group by
SQL
19 votes120 views6 answers
What is mySQL
SQL
2 votes109 views3 answers
Postgres remove foreign key constraint
SQL
2 votes112 views2 answers
Mysql on duplicate key ignore
SQL
0 vote126 views1 answer
Get date from timestamp in mysql
SQL
2 votes124 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote113 views1 answer
Execut sql python
SQL
3 votes114 views1 answer
Postgresql cast
SQL
0 vote116 views1 answer
Sql column as header
SQL