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

0 vote335 views1 answer
Difference between 2 query results sql server
SQL
1 vote350 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote339 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote363 views1 answer
C# sql transaction multiple connections
SQL
0 vote355 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
11 votes336 views5 answers
Sql server reset identity
SQL
0 vote268 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes339 views2 answers
Postgres download
SQL
0 vote295 views1 answer
Mysql create table columns with spaces
SQL
1 vote309 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL