help me..

[innocent]

i'm newbie in php language, so i want to know that how to convert the date from this format (dd/mm/yy) to the (mm/dd/yy). i'm using sql server that store the date data (mm/dd/yyyy). There was an error if i insert 13/1/04(dd/mm/yy) from the form as an instance.

[dragonhawk]

I'm not sure if this would be the best way to do it, but you could use the explode() function

$explode=explode("/",$datevalue);
$day=$explode[0];
$month=$explode[1];
$year=$explode[2];

$newdateformat="$month/$day/$year"; 

Personally though, I would go with the timestamp value and store as an integer instead of the date value

[Ap0s7le]

Are you trying to convert all the current dates in the database to the new format, or simply wanting the form to insert them in the new format?

[innocent]

simply wanting the form to insert them in the new format. Moreover, the error displayd ([Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.)

.
.
.
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO desk (date_no, price, code) VALUES (%s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['date_no'], "date"),
GetSQLValueString($HTTP_POST_VARS['price1'], "text"),
GetSQLValueString($HTTP_POST_VARS['code1'], "text"));
.
.
.

[innocent]

thanks dragon hawk. i made it.