MS SQL Module Chopping Dates
| From: | Flint Doungchak | Date: | Thu, 26 Oct 2000 21:45:05 +0000 |
| Subject: | MS SQL Module Chopping Dates | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-3540@lists.php.net to get a copy of this message | ||
Hello folks,
Using PHP 4.0.3 with SQL Server 7.0 on WinNT 4.0:
This code:
<?
include("../include/db.inc");
$connect = db_connect();
$query = "SELECT GETDATE() as foo";
$result = mssql_query($query,$connect);
$row = mssql_fetch_array($result);
echo "$row[foo]";
?>
spits back this:
Oct 26 2
Any idea why the 2000 is chopped off. I remember writing about this once,
but I don't think I ever got any answer.
-Flint
_________________________________________________
Flint Doungchak
Net Solutions, LLC
840 Lawrence Street
Eugene, OR 97401
flint@netsolutionsllc.com
Voice +1 541 345-7087
Fax +1 541 485-5519
http://www.netsolutionsllc.com