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 vote149 views1 answer
Mysql grant access to one database
SQL
47 votes178 views6 answers
Add column mysql
SQL
0 vote119 views1 answer
Neo4j command to run script file
SQL
9 votes105 views4 answers
Add primary key to existing table sql
SQL
0 vote98 views1 answer
Query on date sqlite flutter
SQL
0 vote109 views1 answer
MySQL error code 2068
SQL
4 votes106 views2 answers
Oracle default date format
SQL
2 votes108 views1 answer
Get first n letter of department name in sql
SQL
1 vote117 views1 answer
Stored procedure return value
SQL
0 vote129 views2 answers
How to list all values of a column that start with a letter in sql
SQL