changing date format

[mubashir]

i hve a date variable in mm-dd-yyyy format how can i change it to mysql default format i.e., yyyy-mm-dd format ...

[jeppers]

Show me your code

[premiso]

www.php.net/strtotime

 

www.php.net/date

 

<?php
$date = "01-01-2007";
$tstamp = strtotime($date);
$newdate = date("Y-m-d", $tstamp);

echo $newdate;
?>

[rajivgonsalves]

or use the mysql function STR_TO_DATE

 

example

 

 

STR_TO_DATE( '07/31/2007', '%m/%d/%Y' )