PHP 4.0 Bug #8423 Updated: Date format in 4.0.3 and 4.0.4 is different for MSSQL
| From: | jlim at natsoft dot com dot my | Date: | Tue, 26 Dec 2000 18:43:29 +0000 |
| Subject: | PHP 4.0 Bug #8423 Updated: Date format in 4.0.3 and 4.0.4 is different for MSSQL | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-42283@lists.php.net to get a copy of this message | ||
ID: 8423
User Update by: jlim@natsoft.com.my
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Description: Date format in 4.0.3 and 4.0.4 is different for MSSQL
Sorry not a bug in PHP. A bug in my brain. Please close.
Previous Comments:
---------------------------------------------------------------------------
[2000-12-26 11:13:15] jlim@natsoft.com.my
The standard data format in all database extensions previously was YYYY-MM-DD hh:ii:ss
The lastest version appears to change it to the following:
27 Dec 2000 12:00AM
Using the TSQL command SET DATEFORMAT YMD does not change it back to y-m-d. The only other thing I
can think of is that I recently upgraded to MDAC/ADO 2.6. Would that cause a problem?
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=8423