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 vote130 views1 answer
Mysql search like but first exact match
SQL
0 vote118 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
10 votes124 views6 answers
Sql between
SQL
0 vote132 views5 answers
Mode sql course
SQL
2 votes122 views1 answer
Mysql sysdate - 1 day
SQL
2 votes123 views3 answers
Replace null in sql
SQL
2 votes120 views1 answer
How to find constraints on a table in oracle
SQL
0 vote81 views1 answer
Check id exist or not in sql
SQL
0 vote118 views1 answer
Mysql select where field is a value
SQL
0 vote216 views1 answer
Get first match in each group mysql query
SQL