note 96230 added to function.mssql-query

From: Date: Tue, 16 Feb 2010 09:37:41 +0000
Subject: note 96230 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-166000@lists.php.net to get a copy of this message
Regarding the problems mentioned on here with the format that datetime columns are returned in. Running on debian lenny and used apt-get install php5-sybase to get access to these functions. After which datetime fields were returned as a string something like 'Feb 16 2010 09:14:10:010AM' which was not recognised when passed to e.g. new DateTime(). Also smalldatetime fields caused php to crash. To fix I did this: vi /etc/php5/apache2/php.ini After this line: ;mssql.datetimeconvert = On Add this line: mssql.datetimeconvert = Off Now both datetime and smalldatetime come back as something like '2010-02-16 09:14:00'. ---- Server IP: 92.48.74.199 Probable Submitter: 81.174.173.253 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- https://master.php.net/note/edit/96230 Del: integrated -- https://master.php.net/note/delete/96230/integrated Del: useless -- https://master.php.net/note/delete/96230/useless Del: bad code -- https://master.php.net/note/delete/96230/bad+code Del: spam -- https://master.php.net/note/delete/96230/spam Del: non-english -- https://master.php.net/note/delete/96230/non-english Del: in docs -- https://master.php.net/note/delete/96230/in+docs Del: other reasons-- https://master.php.net/note/delete/96230 Reject -- https://master.php.net/note/reject/96230 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#166000) next »