This might not be appropriate for web hosting forums but I think someone here might know the answer so please dont delete it.

I am making some forums in perl using a mySQL backend. I have not used any column types such as timestamp, datetime ect. So could someone how I would UPDATE and INSERT into one of those type of columns. I need it to order posts, so it needs to be date and also time. Thanks alot if you can help me with my problem.

Check the mysql manual. It has all the info u need.

To make the question easier to understand really -
for a TIMEDATE field, would the update be:

update messageboards set lastpost = '2002-07-04 04:15:19'
OR
update messageboards set lastpost = '20020704041519'

Do it in exactly the same format returned by a SELECT call.

You can use CURDATE()

Thanks for the replies. I tryed some ways and it seems they worked. Yay for me :D