Jump to content

Archived

This topic is now archived and is closed to further replies.

kpax1684

[SOLVED] How can i get the minuts interval of two dates.?

Recommended Posts

Hello Guys... Im a newbie here i hope im welcome here in phpfreaks forum...

 

Pls need to do this im also a newbie in using PHP..

 

I need to get the minutes interval if two dates..

 

eX: how can i get the minutes interval to this two dates...? :(

date1 = 08-14-2009 08:00:00

date2 = 08-14-2009 09:15:00

Share this post


Link to post
Share on other sites

In PHP:

<?php
  $date1 = '08-14-2009 08:00:00';
  $date2 = '08-14-2009 09:15:00';
  $diff = strtotime($date2) - strtotime($date1); //This gives it in seconds
  $diff_minutes = $diff / 60;
  echo $diff_minutes;
?>

 

But is this coming from MySQL? If so, you can do it right in the MySQL query

Share this post


Link to post
Share on other sites

Hi rhodesa thanks for the very fast reply on my post...

 

This is a very big help since in a beginner in using php...

 

Thanks!

Share this post


Link to post
Share on other sites

hi.... Rhodesa i already tried the code that you've given me,

 

im quite confuse because when i run the script  it return 0 for diff_minutes..

 

Am i missing something..?

Share this post


Link to post
Share on other sites

ah, yes...strtotime() doesn't like the dashes. before we gone down the road of more php code...is this coming from MySQL?

Share this post


Link to post
Share on other sites

if you / instead of - it will work. but are you not using the a date/time datatype in your oracle table?

Share this post


Link to post
Share on other sites

:D YES i am using a date/time datatype in oracle table...

 

The date given in the function is base on system date and time

 

ex: 08/18/2009 08:00:00 i only increment the hour in the given date to become 08/14/2009 09:00:00

 

and then i use this to get the interval of minutes.

Share this post


Link to post
Share on other sites

so, i've never done work with oracle before. have you tried a format like this yet? (assuming your column names are date1 and date2)

 

SELECT (date2 - date1) / 60 FROM tableName

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.