[SOLVED] Timestamp, Datestamp MYSQL. ??

[Snooble]

I have a sql table...

 

NUMBER    DATE

 

I insert,

"5", ""

 

I need the date of the insert to be put in. example: 21-5-2008

 

Is it possible to get SQL to datestamp it automatically? or should i generate the date in PHP and save it too?

 

Snoobs

[JonnoTheDev]

yes

INSERT INTO table SET datefield=CURDATE()

[gevans]

Your best option is to use he linux timestamp

 

time() //in php script

 

or MYSQL functions, TIMEDATE()

 

link

[Mchl]

Use TIMESTAMP DEFAULT CURRENT_TIMESTAMP

[Snooble]

So i alter the database? what type? and i need it to be DD-MM-YYYY.

 

Snoobs

[Mchl]

So i alter the database? what type? and i need it to be DD-MM-YYYY.

 

Snoobs

 

Read here about TIMESTAMP

 

And no. You don't need it to be DD-MM-YYYY. You need to store it as a proper time format and be able to easily convert it to and from DD-MM-YYYY.

[Snooble]

thank you.. SOLVED