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 vote367 views1 answer
Mariadb search columns
SQL
0 vote366 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote344 views1 answer
How to query all tables mysql at the same time
SQL
0 vote393 views1 answer
Create-table-with-index-organization
SQL
8 votes374 views4 answers
Reset SQL auto increment
SQL
0 vote385 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote304 views1 answer
Sqlalchemy filter relationship
SQL
1 vote335 views1 answer
Sql injection
SQL
0 vote360 views1 answer
Sql developer search all packages for text
SQL
0 vote346 views1 answer
Login phpmyadmin without password
SQL