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

5 votes95 views1 answer
Ora-00054 find lock
SQL
48 votes168 views3 answers
Psql create database
SQL
0 vote107 views1 answer
Kill a pid redshift
SQL
1 vote109 views1 answer
Postgres get timestamp
SQL
1 vote105 views1 answer
Oracle extract minute from date
SQL
-2 votes127 views1 answer
Mysql not empty
SQL
1 vote109 views1 answer
Oracle create as select
SQL
1 vote111 views1 answer
Oracle sql average
SQL
0 vote100 views1 answer
Change permission to database mysql
SQL
0 vote235 views2 answers
Mysql insert rows to another database
SQL