[RESOLVED] date format sent to mysql

[big-dog]

How do I make the date from a form be entered into the database as 2007-05-23 (YYYY-MM-DD) Currently it is stored as Wednesday 23rd of April 2007 11:07:26 PM
line 2 I think I needs to change but havent found the right format, every thing Ive tried either errors or simply doesnt store anything. I might add that this is not a user enter date it is the time stamp of when they submitted the form.

$IP = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$Date = date("l jS of F Y h:i:s A");
if($errors==1) echo $error;
else{
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));

[bradgrafelman]

big-dog wrote:

I might add that this is not a user enter date it is the time stamp of when they submitted the form.

Then why even make PHP worry about it?

INSERT INTO myTable (dateColumn) VALUES ( CURDATE() )

Alternatively, replace your date format string with one that would produce the expected format. If you don't have the formats memorized, just check out the table supplied in the manual for the [man]date/man function.

[big-dog]

I have done several differant thing from the date() fuction with no luck.
My form was created with a form genarater and so it pretty much controls what goes into the db.
I just dont understand the coding stuff I guess because Ive tried everything I can find and nothing is doing it.
Can you please help me with the code

$Date = date("l jS of F Y h:i:s A"); 
$Date = date("?????????????");

[NogDog]

$Date = date("Y-m-d");

[big-dog]

Thanks it worked
I tried that but I think I left off the "
Thanks again