retrieving DateTime column from MS-SQL

[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

[kal3003]

try this :

 

$sqlquery="SELECT convert(varchar,DateReceived,103) FROM MyTable";

$results= mssql_query($sqlquery);

 

103 -> dd/mm/yy

101 -> mm/dd/yyyy

and so on you can find all formats in MSSQL help , search for convert