How I Can Get Number Of Minute ?

Question

2.00/5 (1 vote)

See more:

Hello everyone,

it is to calculate the number of minutes between two dates from a table in a MySQL database
my incident table (.., date_creation, hour_creation, date_closing, hour_closing,) I want to know the number of minutes between the date of creating and closing , taking into hours account also.

I need a mysql function OR a PHP script to do this?
thank you in advance

Posted 3-Jul-14 13:29pm

ETTOURI

Add a Solution

3 solutions

Solution 1

This might be what you want:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff[^]

Posted 3-Jul-14 13:38pm

PIEBALDconsult

Comments

DamithSL 3-Jul-14 22:22pm

some one down voted may be because OP saving date and time in different columns and OP can't direct use DATEDIFF function.
But this is way to go, OP should change the database and use this function. I have added my five cents in my Answer[^], 5wd!

Solution 3

I would not save date and time separately, Best practice is use DATETIME column type and save creation and closing date and time. you can use DATEDIFF[^] function and get the total minutes as you need. Otherwise you need to do lot of calculation and effort to combine date and time values separately saved in database and do the calculation. Not that when you need to display Date or Time separately in UI or report you can do it on UI layer. That will help you to even format the dates and times based on client culture.

Posted 3-Jul-14 16:19pm

DamithSL

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohibur Rashid · Accepted Answer · 2014-07-03T14:46:00

I would suggest you to look at
TIMEDIFF[^] function.

PHP way: you need to use mktime functions:
example would be:

PHP

<?php
$time1="2014-04-15 10:10:12";
$time2="2014-04-15 12:10:12";
$time1_int=strtotime ($time1);
$time2_int=strtotime ($time2);
$diff=$time2_int-$time1_int;

$sec=$diff%60;
$minitue=floor($diff/60)%60;
$hour=floor(floor($diff/60)/60);
echo $hour.":".$minitue.":".$sec;

There might be far better solution for this.