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

1 vote231 views1 answer
Importance of comment in mysql
SQL
0 vote182 views1 answer
Hangfire clean script
SQL
0 vote228 views1 answer
Sqlplus change user
SQL
2 votes237 views1 answer
Oracle insert or update
SQL
0 vote234 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
1 vote219 views1 answer
Oracle rolling back
SQL
0 vote239 views1 answer
Oracle swap partition
SQL
2 votes220 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote244 views1 answer
Create table split string function in sql server
SQL
1 vote241 views1 answer
How to select random rows from a table
SQL