MySQL Lists: mysql: basic question

List:	General Discussion	« Previous Message Next Message »
From:	Edward Peloke	Date:	October 11 2002 3:50pm
Subject:	basic question
View as plain text

sql query

when I am defining a table, how do I set the default of a datetime column to
the current time?  I tried setting the default to now()  but it just fills
the column with 00:00 etc..

Thanks,
Eddie

Thread
• basic question	(Edward Peloke)	11 Oct
• Re: basic question	Paul DuBois	12 Oct
• Re: basic question	NZEYIMANA Emery Fabrice	14 Oct