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 vote228 views1 answer
ALV GRID events
SQL
0 vote196 views1 answer
Insert into select with group by
SQL
0 vote196 views1 answer
How to find all children of a record with only parent ID in sql
SQL
3 votes263 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
23 votes191 views1 answer
How remove column in mysql
SQL
0 vote188 views1 answer
H2 auto increment and unique
SQL
1 vote193 views1 answer
Decalre temp table sql
SQL
10 votes188 views3 answers
Insert into auto increment mysql
SQL
1 vote182 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote166 views1 answer
How to create an SQL save method in ruby
SQL