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 Link to comment https://forums.phpfreaks.com/topic/129797-solved-time-and-date-input/ 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 Link to comment https://forums.phpfreaks.com/topic/129797-solved-time-and-date-input/#findComment-673190 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! Link to comment https://forums.phpfreaks.com/topic/129797-solved-time-and-date-input/#findComment-673272 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.