phpBobby

Hi everybody: I'm new to PHP. I'm trying to read from a MS-SQL table and Insert data into MySql. I have difficulties on the DateTime type columns: data shows on the MS-SQL is : 9/1/2006 my query is: $sqlquery="SELECT * FROM MyTable"; $results= mssql_query($sqlquery); I iterate through records by doing: while ($row=mssql_fetch_array($results)) { $drc =$row['DateReceived']; } when I read it: $drc =$row['DateReceived']; and try to show it on the screen (echo $drc) the output is : Sep 1 2006 12:00AM !! Consequently it generates error when I try to insert it into MySql table. Even if I try to format it: date("Y-m-d H:i:s", $drc) still no success :-( Does anybody know why $results return date/time data on such a different format? How can I fix this issue? Many thanks for your help in advance. phpBobby