Date Format in mysql

[Faisal iqbal ch]

i am taking date input from user in a form . User will enter date in mm-dd-yyyy but mysql supports yyyy-mm-dd . Now what is way to change input date to mysql standard format . Like to_date(format,date) function in oracle.

[tubedogg]

Well assuming you are running the form with PHP, sure. Just use the date function. (freddydoesphp will probably come along and give you an easier way but for now, here ya go. )
First convert the users' input into a timestamp and then convert that into the MySQL format.
So,

$userdateinput = str_replace("-",",",$userdateinput);
$timestamp = date("U",mktime(0,0,1,$userdateinput));
$mysqldate = date("Y-m-d",$timestamp);

Then use $mysqldate to put into the db.

[freddydoesphp]

No not at all in fact tubedogg that is a nice way of doing that(the str_replace, I hadn't seen it done that way), except unless you need both of those variables $timestamp and $mysqldate, if not you could simply combine them and save maybe an nth of a second. But thats just me being picky.


$mysqldate = date("Y-m-d",mktime(0,0,1,$userdateinput));

[tubedogg]

hehe Thanks freddy Now that I got my ego boost for the night...