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 Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/ 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 Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900311 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! Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900338 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..? Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900355 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? Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900359 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 "/" Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900365 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? Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900368 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. Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900395 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 Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900553 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 Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-900604 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.. Link to comment https://forums.phpfreaks.com/topic/170704-solved-how-can-i-get-the-minuts-interval-of-two-dates/#findComment-901180 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.