Hello
I am hoping someone can help. We have a system setup here in Boca Raton, FL (USA) where run this code.
<?php
$server='GRATCQ02.ths.siemens.gr,1433';
$username="frdb_id";
$password="testing";
$sqlconnect=mssql_connect($server,$username,$password) or die ("Could not connect to database: ".mssql_get_last_message());
;
$sqldb=mssql_select_db("northwind",$sqlconnect);
$sqlquery="SELECT mydate1 from dd";
$results=mssql_query($sqlquery);
while ($row=mssql_fetch_array($results))
{
echo $row['mydate1']."<br>\n";
}
mssql_close($sqlconnect);
?>
this returns [Jan 1 1900 12:00AM]
now this same code is on a server in Athens, Greece and we get a different result
we get - [1 Jan 1900 0:00]
I understand that changing the code to a unicode format would probably be the best solution but we don't have that ability right now - we don't own code :mad: and owner says it's in too many places to change :eek: and we are being pressed by management to get this corrected quickly.
We thought possible the regional date/time setting on the Windows 2003 server box would be the issue but that doesn't seem to change anything.
Wondering if anyone else had a similar issue? or any suggestions 
thanks
Kellie Verrelli