......MySql DATE().

[russian_god]

HI!
I have a form that adds stuff to the database........
and when it is added i want to record time(date) of adding.....
I have a column date in MySql and i tried CURDATE() it works but i want another format of displaying it.... i want it to be day/month/year and CURDATE() displays year/monts/day......
does any one know how can i change that?????/

[bestpricehost]

Hi there! In the table add a field with datatype='date', and in the query use like this.
insert into table (date) values ('now()').

This is a mysql function and adds current date and time.

Regards
T. A. Barry

Get FREE domain with every hosting.
So many features just for $79.99 per yr.
www.BestPriceHost.com