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

3 votes154 views3 answers
Docker create postgresql database
SQL
0 vote135 views1 answer
Full syntax inner join
SQL
0 vote173 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote159 views3 answers
Magento 2 order delete from db
SQL
0 vote155 views1 answer
Sql ignore
SQL
10 votes152 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote193 views2 answers
Laravel jwt generate token
SQL
0 vote186 views1 answer
Alter database name script
SQL
0 vote150 views3 answers
Condition in count sql
SQL
7 votes154 views1 answer
Mysql remote connection command line
SQL