Mateobus Posted November 23, 2006 Share Posted November 23, 2006 Hello all, I am trying to maintain a clock in a database and I am having trouble doing so. I have tried reading the php manuals for various functions but its all a bit over my head. I am wondering how you would take a timestamp (perhaps from mysql, or perhaps php time) and subtract a certain amount of time from it. In the end, I just want to update a variable that is of type time in mysql: 00:00:00.[code]$timenew = now$timeold = get_time_from_database$difference = timenew - timeold update database time=difference[/code]Sorry for my pseudocode, but any help is appreciated Link to comment https://forums.phpfreaks.com/topic/28209-subtracting-time/ Share on other sites More sharing options...
HuggieBear Posted November 23, 2006 Share Posted November 23, 2006 I would have thought that MySQL's functions would be better for this. I can't get to the MySQL manual at the minute, but something like this I'd imagine:[code=php:0]$sql = "SELECT curtime() - time_column AS difference FROM timetable";[/code] This will give you the difference in seconds between the two times.RegardsHuggie Link to comment https://forums.phpfreaks.com/topic/28209-subtracting-time/#findComment-129048 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.