creating datetime in mysql table

[oriola1]

hey guys
Am trying to store dateand time in mysql table that wil show date n time that a row was enter with this table code
product_date datetime NOT NULL default NOW(),
Bt it gives error of invalid default value so i remove the default NOW() then it create the table bt when i inserted into the table and view my database the colomn for datetime it was 000000000.
plz who understand the reason shud help me
Thank in anticipation

[ionezation]

http://www.google.com.pk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&ved=0CEAQFjAD&url=http%3A%2F%2Fwww.kbedell.com%2F2009%2F03%2F07%2Fhow-to-create-a-timestampdatetime-column-in-mysql-to-automatically-be-set-with-the-current-time%2F&ei=yP5hU4rHGYWxOa3LgIgJ&usg=AFQjCNEWotC71qoau2JbNkHzTffanIzulw&bvm=bv.65636070,d.ZWU

[ionezation]

hope this works for you !

[oriola1]

Thanks man i wil try it and get back to u

[ionezation]

Thanks bro ... Ask anything will be answered :)