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

22 votes172 views4 answers
Mysql format date
SQL
8 votes134 views2 answers
Mysql get first x characters
SQL
0 vote151 views3 answers
Mysqli count down
SQL
4 votes133 views2 answers
How to count items with same name in sql
SQL
0 vote129 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
6 votes139 views1 answer
Oracle pl sql source
SQL
0 vote119 views1 answer
Duplicate foreign key constraint name
SQL
26 votes138 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote126 views1 answer
Oracle lock user
SQL
0 vote132 views1 answer
Sql pivot without aggregate
SQL