N-Bomb(Nerd) Posted June 17, 2009 Share Posted June 17, 2009 Hi, I have a field in my database that I would like to have the current date/time of when that row was added. How would one go about this? Is it possible that I could use phpmyadmin and have the date automatically set so that's one less thing I have to worry about in my queries? I'm using a MySQL5.0 database, just in case that matters. Thanks, Link to comment https://forums.phpfreaks.com/topic/162527-inserting-datetime/ Share on other sites More sharing options...
Dathremar Posted June 17, 2009 Share Posted June 17, 2009 just use: "INSERT INTO table_name ( column1, column2, column3 ) VALUES ( 'value1', 'value2', now() )"; read this time and date functions Link to comment https://forums.phpfreaks.com/topic/162527-inserting-datetime/#findComment-857792 Share on other sites More sharing options...
N-Bomb(Nerd) Posted June 17, 2009 Author Share Posted June 17, 2009 just use: "INSERT INTO table_name ( column1, column2, column3 ) VALUES ( 'value1', 'value2', now() )"; read this time and date functions Ah ok, I remember the NOW() function.. I wish if I knew if there was a way to have the date field automatically be set to NOW() within phpmyadmin.. would save me a lot of work Link to comment https://forums.phpfreaks.com/topic/162527-inserting-datetime/#findComment-857796 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.