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 vote164 views1 answer
Oracle user last connected
SQL
-1 vote123 views1 answer
Oracle db list usernames
SQL
0 vote184 views1 answer
Psql generate id in existing database
SQL
3 votes215 views2 answers
Find string in stored procedure sql server
SQL
0 vote181 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote160 views1 answer
Equi joins in oracle
SQL
1 vote165 views1 answer
Loading local data is disabled mysql
SQL
0 vote178 views1 answer
Drop column from table if exist on live server mysql
SQL
8 votes163 views3 answers
Alter user root mysql
SQL
1 vote178 views1 answer
SQLSTATE[HY000] [2002]
SQL