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 vote145 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote134 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote144 views1 answer
What does leave do in mysql
SQL
3 votes223 views2 answers
Savepoint in sql
SQL
0 vote140 views1 answer
Mysql xampp reset root password
SQL
0 vote142 views1 answer
Sql auto_increment syntax
SQL
2 votes158 views3 answers
Sql interview query questions
SQL
4 votes152 views2 answers
REST API
SQL
0 vote145 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote142 views1 answer
Dump only data
SQL