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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
