In your query, you need to set the value of that field to NOW() which is MySQL's function for getting a timestamp of the current time.

If you put your actual query in your question, I can help you with a more specific answer ;)

• I want to display the current date and time of the users time zone in the format ("Y-m-d H:i:s") PHP

  Possible Duplicate: Timezone conversion in php How to get client's timezone? I want to display the current date and time of the users time zone in the format ("Y-m-d H:i:s") PHP …

• how to insert the current timestamp into mysql db using a php insert query

  In my database (mysql), i have a table with structure - username - varchar insert_time - timestamp this table was created in mysql using the phpmyadmin tool, and for the insert_time column, i hav…

• How do I get the difference between a mysql timestamp and the php current time?

  The question i guess is kind of 2 questions: How do i even GET the current time in php and in a format that is easily compared to and Once i have that, i have a mysql timestamp in this format…

• How to calulate the difference between a MySQL timestamp and the current time in PHP

  I'm trying to calculate the difference between a timestamp retrieved from a MySQL database and the current time. Appreciate the help.

• MYSQL: Convert Timestamp --> Time

  I have this MYSQL Table: [ID] [TIMESTAMP] [TIME] [1] [2010-05-29 01:17:35] [] [1] [2010-05-29 01:23:42] [] ... and so on Now I need to copy the TIMESTAMP value into the TIME rows. The new …

• Getting a Date Range in MySQL form a UNIX Timestamp in PHP

  I have a UNIX timestamp in a table like 1321521158 and want to get the details from a table for the particular date, like: $mydate="11/11/2011"; SELECT notes FROM table WHERE `addeddate`=$mydate …

• How do I convert between time formats?

  I am looking to convert a mysql timestamp to a epoch time in seconds using php, and vice versa. What's the cleanest way to do this?

• If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?

  I'm interested in doing comparisons between the date string and the MySQL timestamp. However, I'm not seeing an easy conversion. Am I overlooking something obvious?

• How to check if a date has passed

  I am trying to check if a date has passed or if it is the future. If the end_date has passed then I do not want it to display. end_date is a MySQL timestamp. Right now all news articles are displayi…

• Time completion in working hours

  Okay, not so much a programming problem, but I can only seem to think of really complicated methods to solve this. There is a script we run in the office. We need to determine how long this scrip…