How to get the date difference in MySQL?

Asked By Catherine Brewer 10 points N/A Posted on - 11/20/2012

 

I want to know the process to find the date difference in mysql in a emergency basis. Can anyone help?

• Status: Open
• Question Views: 1297
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by Jayson03

Go To Solution

Answered By Aurtt munguia 0 points N/A #151948

How to get the date difference in MySQL?

You can use the DATEDIFF function

It's pretty simple and you can use it to find the difference between two dates as long as the dates are valid

 

the syntax is DATEDIFF( 1st date , 2nd date )

ex: SELECT DATEDIFF('2012-11-20','2008-11-20') AS DateDifference

 

Note : If you used the date/time format the difference will be calculated from the date only

About Aurtt munguia

Questions
1

Answers
66

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 11/20/2012
• Question Category: Misc Software

Best Answer

Best Answer

Answered By Jayson03 0 points N/A #151949

How to get the date difference in MySQL?

 

In SQL, to dynamically get the current date (and time) you will need to type the following codes

select getdate()

 

And to calculate the difference between two dates and get the result in days, months, years or minutes your syntax should be like this:

Days:select datediff (d, fromDATE, toDATE)

Months:select datediff (mm, fromDATE, toDATE)

Years:select datediff (yy, fromDATE, toDATE) 

Minutes:select datediff (mi, fromDATE, toDATE)

 

About Jayson03

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/21/2012
• Question Category: Misc Software