MS SQL date time strangeness

From: Date: Mon, 26 Jan 2004 20:38:39 +0000
Subject: MS SQL date time strangeness
Groups: php.db 
Request: Send a blank email to php-db+get-32627@lists.php.net to get a copy of this message
I have Apache 1.3 and PHP 4 running on Windows 98 connecting to a local MS SQL 7.0 server. MS SQL has the date as 2004-01-09 (YYYY-MM-DD), when I print the date to a webpage with this PHP code: printf("Date Picked Up: %s\nDate", date("Y/j/n",$row[0]); I get this output: 1969/12/31 What is wrong?

« previous php.db (#32627) next »