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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/28209-subtracting-time/#findComment-129048 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.