kpax1684 Posted August 17, 2009 Share Posted August 17, 2009 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 Quote Link to comment Share on other sites More sharing options...
rhodesa Posted August 17, 2009 Share Posted August 17, 2009 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 Quote Link to comment Share on other sites More sharing options...
kpax1684 Posted August 17, 2009 Author Share Posted August 17, 2009 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! Quote Link to comment Share on other sites More sharing options...
kpax1684 Posted August 17, 2009 Author Share Posted August 17, 2009 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..? Quote Link to comment Share on other sites More sharing options...
rhodesa Posted August 17, 2009 Share Posted August 17, 2009 ah, yes...strtotime() doesn't like the dashes. before we gone down the road of more php code...is this coming from MySQL? Quote Link to comment Share on other sites More sharing options...
kpax1684 Posted August 17, 2009 Author Share Posted August 17, 2009 Nope this is came from oracle, but i can format the dates to "/" Quote Link to comment Share on other sites More sharing options...
rhodesa Posted August 17, 2009 Share Posted August 17, 2009 if you / instead of - it will work. but are you not using the a date/time datatype in your oracle table? Quote Link to comment Share on other sites More sharing options...
kpax1684 Posted August 17, 2009 Author Share Posted August 17, 2009 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. Quote Link to comment Share on other sites More sharing options...
rhodesa Posted August 18, 2009 Share Posted August 18, 2009 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 Quote Link to comment Share on other sites More sharing options...
tolutlou Posted August 18, 2009 Share Posted August 18, 2009 thanx friends i waz also search this coding for last few days thanx again _____________________________ babysitting games www.totalwargamer.co.uk Quote Link to comment Share on other sites More sharing options...
kpax1684 Posted August 18, 2009 Author Share Posted August 18, 2009 Hi Rhodesa my was solve thanks again for the help.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.