Re: Insterting date in an MySQL table

Maybe you can also use this syntax: select date_format(now(), '%Y.%m.%d') name_of_the_column Dalibor charalambos nicolaou napsal(a):

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