Change field to automatically enter current date on insert query
I wish to change a field from varchar to automatically enter the current date upon insert of new rows. How should that field be structured? mySql version is 5.5.30, phpMyAdmin version is 3.5.5
Last edited by jwgrafflin; 08-27-2013 at 12:41 PM.
If you make it a TIMESTAMP type, you can set the default value to NOW()
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)