"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

Reply via email to