JustinK101 Posted October 2, 2006 Share Posted October 2, 2006 Hello, I need to preform a date/time conversion.I have the following data: $date which stores a date in mysql format, yyyy-mm-dd$time which stores the time in mysql format hh:mm:ssThen I need to grab the current date and time from the server and subtract the difference from the current date/time against my custom $date/$time and return the result in the form of hours. So an hour and half from the current date/time to the stored date/time would be returned as 1.5, etc. Thanks much! Quote Link to comment Share on other sites More sharing options...
JustinK101 Posted October 3, 2006 Author Share Posted October 3, 2006 here is my solution, I think this works, any better way of doing it though?$my_date = $row[0]; $my_time = $row[1]; $my_epoch = strtotime($my_date . "T" . $my_time); $this_epoch = time(); $total = ((($this_epoch - $my_epoch) / 60) / 60); $total = round($total, 2); Quote Link to comment Share on other sites More sharing options...
ponsho Posted October 3, 2006 Share Posted October 3, 2006 list($year,$month,$day) = explode("-",$date);list($hour,$min,$sec) = explode(":",$time);$time = mktime(date("h"),date("i"),date("s"),date("m"),date("d"),date("Y"));$time2 = mktime($hour,$min,$sec,$month,$day,$year);$total = round(($time-$time2)/3600,2); Quote Link to comment Share on other sites More sharing options...
JustinK101 Posted October 3, 2006 Author Share Posted October 3, 2006 ponsho:Interesting, thanks, your code is nice, though I think a bit harder to read, probably just my personal preference though. 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.