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 vote286 views1 answer
Sql server system messeges
SQL
0 vote286 views1 answer
Sql insert from excel
SQL
0 vote280 views1 answer
Mysql count by month
SQL
1 vote301 views3 answers
Rows, INSERT INTO
SQL
2 votes267 views2 answers
Mysql all columns
SQL
0 vote287 views1 answer
Mariadb errno 121
SQL
4 votes317 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote279 views1 answer
Online sql testing tool
SQL
-1 vote304 views5 answers
Convert sql to linq query online
SQL
0 vote305 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL