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 votes199 views1 answer
Oracle list invalid password logon denied
SQL
1 vote175 views3 answers
Sql server get week dates from week number
SQL
0 vote180 views1 answer
Sql show all users
SQL
0 vote184 views1 answer
Wordpress sql change site url
SQL
0 vote195 views1 answer
Sql put two columns into one
SQL
0 vote174 views1 answer
Commit transaction sql
SQL
3 votes179 views2 answers
Mysql update row
SQL
11 votes206 views2 answers
Set default column value sql
SQL
0 vote182 views1 answer
Postgres sql alter table delete row
SQL
0 vote173 views1 answer
Get number of table colums in sql query
SQL