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 vote260 views1 answer
Sql commands in android
SQL
0 vote222 views1 answer
Download sql file of countries names
SQL
0 vote183 views1 answer
Learn sqlite dart
SQL
0 vote206 views1 answer
Mysql check datetime equals date
SQL
0 vote233 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote241 views1 answer
Postgresql import data from csv
SQL
1 vote185 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote221 views1 answer
UseSqlServer no definition
SQL
0 vote244 views1 answer
Find duplicate users by email address in mysql
SQL
2 votes188 views2 answers
Spring import sql
SQL