Setting today's date in PHPmyADMIN

mysql_query · Oct 8, 2002

Hello. How can I set the default to be today's date in one of the feilds in PHPmyADMIN? Help is appreciated.

Thanks.

tha_mink · Oct 8, 2002

UPDATE tablename SET datefield=CURDATE() where [condition];

that assumes your format is XXXX-XX-XX.

Alternately you could make your column type a timestamp(14) which will timestamp the record every time your create one or update one.

mysql_query · Oct 8, 2002

Thanks mink.

I set it it to TIMESTAMP in PHPmyADMIN, with a null value. That automatically fills new submissions in with today's date.

Thanks again.