Page 1 of 1

ODBC sage line 50, date fields create strange characters

Posted: Wed Mar 24, 2010 9:11 am
by oli2020
Im having problems with getting dates out of an odbc connection (sage).

Here is a example.
$dbh = odbc_connect('SageLine50v16', "manager", "");

$sql="SELECT RECORD_CREATE_DATE FROM COMPANY";
$result_data = odbc_exec($dbh,$sql);
while ($row = odbc_fetch_array($result_data)) {
echo $row['RECORD_CREATE_DATE'];
}

On my browser it produces 201ger!<REC (with the arrow filled in style) when opened to view source it just shows 201, so I belive it to be a unrecognised character set.

when the odbc connection is opened via Microsoft Access it converts the date correctly to "14/03/2010 12:39:01" . Is there a way at the SQL level or php level to convert this to a readable string. Anyones help on this would be greatly appreciated. Has anyone had this problem before?

All the best.
Oli