Re: mssql datetime field

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, Jeffrey_N_Dyke@Keane.com 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 Michael.Bretterklieber@jawa.at homepage: http://www.jawa.at --------- privat ----------- E-mail: mbretter@inode.at 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