next → ← prev

MySQL Date/Time Subdate() Function

The subdate() is a MySQL date/time function. It is used to get the date which is subtracted by given intervals.

Syntax

Select subdate(date, interval value unit);
			kOr
	  Select subdate(date, days);

Parameter

Date : date by which interval is to be subtracted.

Days : number of days in which interval is to be subtracted.

Value : time or date interval to be subtracted.

Unit : type of interval such as DAY, MONTH, MINUTE, HOUR and so on. Following can be one of them.

UNIT	COMPATIBILITY
MICROSECOND	4.1.1+
SECOND	3.2.3+
MINUTE	3.2.3+
HOUR	3.2.3+
DAY	3.2.3+
WEEK	5+
MONTH	3.2.3+
QUARTER	5+
YEAR	3.2.3+
SECOND_MICROSECOND	4.1.1+
MINUTE_MICROSECOND	4.1.1+
MINUTE_SECOND	4.1.1+
HOUR_MICROSECOND	4.1.1+
HOUR_SECOND	4.1.1+
HOUR_MINUTE	3.2.3+
DAY_MICROSECOND	4.1.1+
DAY_SECOND	3.2.3+
DAY_MINUTE	3.2.3+
DAY_HOUR	3.2.3+
YEAR_MONTH	3.2.3+

Returns

This unction returns the date which is subtracted by given intervals.

Example 1

MySQL Subdate() Function

MySQL Subdate() Function

MySQL Subdate() Function

MySQL Subdate() Function

MySQL Subdate() Function

Next TopicMySQL datetime

← prev next →

Latest Courses

Data-Structures

Cloud-Computing

Ethical-Hacking

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Follow us

Tutorials

Java Data Structures C Programming C++ Tutorial C# Tutorial PHP Tutorial HTML Tutorial JavaScript Tutorial jQuery Tutorial Spring Tutorial

Interview Questions

Tcs Intuit Wipro Adobe Infosys Amazon Accenture Cognizant Capgemini Microsoft

Online Compiler

C R C++ Php Java Html Swift Python JavaScript TypeScript

© Copyright 2024 Javatpoint. All Rights Reserved.