pumaf1 Posted October 23, 2008 Share Posted October 23, 2008 Hi, I am trying to write a very simple "noticeboard" app for my website, something very very simple. I would like ti when a user posts a comment for the system to automatically enter the date and time of that post something like dd/mm/yy @ hh:mm I have benen looking all day and I cant see anything for this? can anyone please help me? regards Dave Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted October 23, 2008 Share Posted October 23, 2008 The mysql NOW() function can be used directly in a query to give the current date/time that would be usable in a DATETIME data type (which is how you should be storing the date/time in a database.) Ref: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_now Quote Link to comment Share on other sites More sharing options...
pumaf1 Posted October 23, 2008 Author Share Posted October 23, 2008 thank you - i was loking at php not actually on the Database - thanks! Quote Link to comment 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.