date mysql

[Anon]

I'm sure this a realy easy question but i couldn't find something like it in the forum. I'm using a form to populate a MYSQL database and one of the fields is a date field. I would idealy like to to populate the date field by using the server date . I've tried using tryied using sysdate to do that but it doesn't work. Can I even do something like that?
Or is there a way i could convert mm-dd-yyyy to yyyy-mm-dd. If the user enters the date as mm-dd-yy, and the database wants it as yyyy-mm-dd?

thank you

[[deleted]]

Why don't you just to

INSERT INTO table
SET date_field = now();

[Anon]

when i do that i get 0000-00-00 for the date field it doesn't specify a date.