"Charalambos Nicolaou" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi everyone, > > I want to created a MYSQL table which will get the date in the form > (YYYY-MM-DD) automatically. I have created the table below but it doesn’t > get the form of date that I want. It has the form (YYYYMMDDHHMMSS) > > CREATE TABLE questions1 (ID INT NOT NULL AUTO_INCREMENT,name VARCHAR(30),day > TIMESTAMP,question TEXT,email VARCHAR(30),answer TEXT, PRIMARY KEY(ID)); > > Is there any other date field that gets the date form as I want?
Use the column type date - this is what you want. Regards, Torsten > > Thanks in advance > > Charalambos Nicolaou > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php