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

2 votes254 views2 answers
Sqlite_busy: database is locked
SQL
0 vote287 views2 answers
Alter table add multiple columns mysql
SQL
0 vote311 views1 answer
Sql decimal to 2 places
SQL
10 votes263 views1 answer
How to import database in mysql by cmd
SQL
0 vote285 views1 answer
Create tables from xsd to sql server database c#
SQL
-1 vote288 views1 answer
Round up and down sql
SQL
0 vote292 views1 answer
What does leave do in mysql
SQL
0 vote271 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
92 votes490 views6 answers
Substring
SQL
0 vote300 views1 answer
Flask sqlalchemy. commit does not save changes
SQL