Sql

Search

mysql get last day of month

SELECT LAST_DAY(CURDATE());						-- Current month
SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH);	-- Previous month
SELECT LAST_DAY(CURDATE() + INTERVAL 1 MONTH);	-- Next month

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql show processlist full query
Sql :: oracle check table lock
Sql :: if date is today mysql
Sql :: mysql check table exists
Sql :: mysql timestamp in laravel migration
Sql :: how to check when a stored procedure was last modified in sql server
Sql :: mysql delete row
Sql :: postgresql concatenate multiple rows in group by
Sql :: top 10 rows in mysql
Sql :: postgres restart id
Sql :: mysql slave status
Sql :: oracle compile schema
Sql :: how to get current mysql version
Sql :: mysql import sql file
Sql :: show databases mysql docker
Sql :: mysql get db name
Sql :: django sqlite database
Sql :: postgres drop column if exists
Sql :: check database size sql
Sql :: create table mysql query
Sql :: mysql where in array
Sql :: postgresql show current database
Sql :: how to select department from table
Sql :: how to check nls format in oracle
Sql :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
Sql :: oracle export view ddl
Sql :: mysql get character set
Sql :: list columns in table postgres
Sql :: check mysql port
Sql :: What is localhost IP and MySql default port no.

Search

SQL

mysql get last day of month

ADD CONTENT