Re: MS SQL date time strangeness

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I tried what you had suggested and I still get the same result.



Robert Twitty wrote:
The date() is for use with the 32-bit C time value returned by functions
like time().  Data from fields of type datetime are returned as strings in
the form Jan  9 2004 by the mssql extension as the default. To return it
using ISO format set mssql.datetimeconvert to "On" in the php.ini file, or
use the following command:

ini_set('mssql.datetimeconvert' , 1 );

-- bob

On Mon, 26 Jan 2004, Steve wrote:


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

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux