Adding value to Time Stamp

tonyaligenclik

New Member
I am trying to create a script for quiz. I have stored current time stamp in mysql DB as quiz start time, and want to check after each quiz how much time is left. I have the idea that I will add 30 mins to saved time stamp and subtract this value from current time. That will be the time left. But I don't know the exact way of doing this. My time stamp is saved in DB in fromat 2010-08-24 20:08:59. Any one have the idea.Please let me know if someone have done it, or know how to get it.Adding 30 mins to time stamp and showing the user how much time is left.I am using the now() function to store the timestmp in DB.Thanks
 
Back
Top