Insterting date in an MySQL table

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? Thanks in advance Charalambos Nicolaou _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus