Hi,
there exists a workaround in php for this problem. Just put in your php.ini:
mssql.datetimeconvert = 0
or in your script:
ini_set('mssql.datetimeconvert' , 0);
this causes date values in this format: YYYY-MM-DD HH24:MI:SS
if it doesen't work correctly, the upgrade to php4.2.1
bye,
[EMAIL PROTECTED] schrieb:
> has anyone had any expierence with the datetime field coming back from
> MSSQL as someting along the lines of February 3, 2036 6:36AM. This
happens
> to me no matter the time in the database. PHP inserts it correctly, but
> the select has a problem. I am using php4.1.2 and SqlServer 7.0.
>
> Or is anyone haveing success, in new versions of PHP. Upgrading PHP
is no
> problem, upgrading SQL is not an option
>
> Thanks in advance.
> Jeff
>
>
>
--
--------------------------------------
Michael Bretterklieber
LCP
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
[EMAIL PROTECTED]
homepage: http://www.jawa.at
--------- privat -----------
E-mail: [EMAIL PROTECTED]
homepage: http://www.inode.at/mbretter
--------------------------------------
"...the number of UNIX installations has grown to 10, with more expected..."
- Dennis Ritchie and Ken Thompson, June 1972
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
