[RESOLVED] Inserting time and dates to a mysql db

[Megahertza]

I'm in the design phase of my first mysql/php news page. I'm woundering if i need to insert a date and time into the table for every news article or if mysql automatically assigns dates and times to row entry. If so how can i extract the time the entry was made. Are there any problem doing this way. thanks guys.

[Onurphp]

You can try DATETIME IN SQL and you can use NOW() function in MYSQL like this

table :

`id`  int auto_increment not null,
`date` DATETIME,

SQL QUERY :

INSERT INTO table (id,date) VALUES ('1',NOW());

[Megahertza]

thanks dude