MySQL Date Datatypes

Anon

Hi,
I'm creating a simple guestbook and I want to enter the date someone posts a message in the MySQL table. I know of timestamp and date etc but I am not sure how to actually add the data to the table?

Thanks for any help,

Jord

Anon

I'm not certain about mySQL, but usually date literals are passed to the server engine in between pound (#) signs:

UPDATE mytble SET DateField=#06/27/2000# WHERE ...

Anon

MySQL has some functions to include the current date (use CURDATE() for this).

MySQL also has some different types for the columns of the database. As I believe correctly there is DATE as well as TIME.

But I am also just looking at MySQL. Last week I did some coding with it, but that does not make me an expert.

Anon

Hi,
Thanks for your help guys. It seems to enter something in the datatabse but it's a matter of pulling them out now.

Cheers,

Jord

Anon

<? hello i am a script ?>