Javatpoint Logo
Javatpoint Logo

MySQL DATEDIFF() Function

The datediff() is a MySQL date/time function. It is used to get the difference between two date values.

Syntax

Parameter:

date1 & date2 : date's for calculating the difference.

Returns

This function returns the difference in days between two date values.

Example 1

Output:


MySQL DATEDIFF() Function

Example 2

Output:


MySQL DATEDIFF() Function
Next TopicMySQL date/time




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

Ionic Tutorial

Ionic
VHDL Tutorial

VHDL
Tensorflow Tutorial

Tensorflow
Data Mining Tutorial

Data Mining
Xamarin Tutorial

Xamarin
Ansible Tutorial

Ansible
Matplotlib Tutorial

Matplotlib
Wireshark Tutorial

Wireshark
Git Tutorial

Git
Jupyter Notebook Tutorial

Jupyter
QlikView Tutorial

QlikView
R Tutorial

R

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal A.
Interview Questions

Interview
Company Interview Questions

Company

Trending Technologies

Artificial Intelligence Tutorial

AI
AWS Tutorial

AWS
Selenium tutorial

Selenium
IoT Tutorial

IoT
Cloud tutorial

Cloud
Hadoop tutorial

Hadoop
ReactJS Tutorial

ReactJS
React Native Tutorial

React Native
Node.js tutorial

Node.js
Data Science Tutorial

D. Science
Angular 7 Tutorial

Angular 7
Blockchain Tutorial

Blockchain

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

DS
DAA tutorial

DAA
Operating System tutorial

OS
Computer Network tutorial

C. Network
Compiler Design tutorial

Compiler D.
Computer Organization and Architecture

COA
Discrete Mathematics Tutorial

D. Math.
Ethical Hacking Tutorial

E. Hacking
Computer Graphics Tutorial

C. Graphics
Software Engineering Tutorial

Software E.
html tutorial

Web Tech.
Cyber Security tutorial

Cyber Sec.
Automata Tutorial

Automata
C Language tutorial

C
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control S.