将当前日期存储在数据库中

Question

I am using the NOW() function to store date in the database. But when i check the values in the database, the date is something else.

   $sql="INSERT INTO feedback_comments 
       (posted_by, email, comments_text, comment_date)
   VALUES
       ('$postedBy','$emailID','$message',NOW())";

Answer 1

Is it always off by the same amount? If so, it's likely to be either a configuration difference in times between your database and PHP environment, or even two different times if they're running on separate boxes.

The other possibility is that the type of the column you're inserting in to is not correct. In that case, you'll probably get something like 20071215235026.000000 instead of '2007-12-15 23:50:26'.