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, Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/162527-inserting-datetime/#findComment-857796 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.