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 vote156 views1 answer
Java spring boot connect to sql server
SQL
0 vote224 views1 answer
Split first name and last name in sql
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL
0 vote200 views1 answer
Remove transient options sql wordpress
SQL
1 vote197 views1 answer
Update from table tsql
SQL
0 vote174 views2 answers
How to start postgresql laravel
SQL
18 votes195 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote205 views2 answers
SQL FROM
SQL
1 vote180 views1 answer
Using SQL in rails migration
SQL
1 vote195 views1 answer
Oracle case
SQL