?
Solved

Php or My sql calculate the time in month

Posted on 2008-01-25
1
Medium Priority
?
206 Views
Last Modified: 2008-03-05
2007-01-02 00:00:00
2007-03-03 00:00:00

Mysql database is have format like above how can  minus time 2007-03-03 00:00:00 - 2007-01-02 00:00:00 the result should Be 3  I calculate in month
0
Comment
Question by:teera
1 Comment
 
LVL 26

Accepted Solution

by:
ee_rlee earned 1400 total points
ID: 20741060
use
datediff(month,date1,date2)
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question