Inserting the current date...

[arik00]

i have a mysql table which has a date column called DateStarted, with a default value of '0000-00-00'.
every time i tried to insert the date, it only inserted '0000-00-00'.

i first get the current date with my function "getdate":

function get_date() {
$thedate = date("Y-d-m");
return $thedate;
}

and use the following insert statement:
"INSERT INTO projects (YearID, DateStarted,Info,ProjTitle) VALUES ('$yearid','$datestarted','$info','$projtitle')"

when $datestarted is the value returned by the get_date function.

thanks in advance
Arik :rolleyes:

[arik00]

well, i didn't think it would be that hard...
but thanx anyway...

Arik 🙁

[[deleted]]

You may want to consider actually giving us a few seconds to read your post. 33 minutes is not a lot of time.

Anyway, the current date is called 'NOW()' in SQL:

INSERT INTO table (date_field) VALUES(NOW());

[RazorSA]

When I had a field in MySQL formatted to Date 0000-00-00 it would only accept 2002-12-31. (YYYY-MM-DD)

I think you are trying to force it to save (YYYY-DD-MM)

I am just a Noobie so please dont jump down my throat if I am wrong.