Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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. 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =