[SOLVED] MySQL DateTime -&- PHP Date()

[hungryOrb]

Hallo, trying to put a PHP Date() into my MySQL db DATETIME column, but ehh.. its saying:

 

Error: Incorrect datetime value: '' for column 'Started' at row 1

 

This makes me sad, is anyone knowing exactly what format I should use to store PHP's date function in my database properly?

 

I nub. Sari

[ToonMariner]

date in mysql is YYYY-MM-DD

 

if you use date time its YYYY-MM-DD HH:MM:SS

 

make sure your php dates reflect that - date('Y-m-d') or date('Y-m-d H:i:s');

[hungryOrb]

Thankyou very much for showing me the format!

however, it is stil giving the same message, must I put something between date('Y-m-d H:i:s');  the date, and time?

[ToonMariner]

well if you are not using the current date and time you need to use date('Y-m-d H:i:s', mktime(#timestamp of your date/time#))

[hungryOrb]

Yes, using the current server time.

As follows:

 

$started_query = mysql_query("SELECT Started FROM jobs
WHERE
`ID`='".$_POST["id"]."'");

IF (($_POST['started'] == "chk") && ($started_query == ""))
	{ 
	$started_store = date('Y-m-d H:i:s');
	}

$sql="UPDATE jobs SET `Started`='".$started_store."'
WHERE
`ID`='".$_POST["id"]."'";

 

Just want to put it straight into a var, then directly into the database.. :'(

ty for help though ;]

[madspof]

I dont know what field type you are using to store the date and time but i use varchar and it works fine also make sure the field is set, so that it allows enought characters for the date

[hungryOrb]

hm, thanks. Not sure If I wanna give up on my DATETIME field type atm!

BUT-! hmm, what do you mean by the field being seT? You mean throw some generic values in the appropriate format in there to simply replace with UPDATE? If so, then my IF statement becomes worthless

[madspof]

I mean so that the field can acept how long the date and time recorded is like if it is 10 characters and the field is set to only 5 it will not acept all the characters

[hungryOrb]

Oh I see, please could you tell me how to do this? ;]]]]

[madspof]

Okay well what database are you using

[hungryOrb]

MySQL and the database name is ITDB.

[madspof]

I guess you have somekind of program like phpadmin to access the db

 

[hungryOrb]

ehm, just changing the field types and stuff in MySQL Query Browser

[hungryOrb]

Arg!

[ToonMariner]

if you are just inserting the current time use NOW() in teh mysql query and don't bother with any of teh php date stuff - its unnessesscary!

[hungryOrb]

Thanks guys, got it solved with all of your help and some messing with stuff ;]