ID: 38502 Updated by: [EMAIL PROTECTED] Reported By: kecso at i-trade dot hu -Status: Open +Status: No Feedback Bug Type: MSSQL related Operating System: debian PHP Version: 5.1.5 New Comment:
This sounds more like a configuration problem with freetds. Please reconfigure using --enable-msdblib. Previous Comments: ------------------------------------------------------------------------ [2006-08-18 15:28:54] kecso at i-trade dot hu Description: ------------ Hi! MYSQL version: MySQL 5.0.22-Debian_1.dotdeb.1-log PHP version: PHP Version 5.0.5-Debian-0.8~sarge1 (Debian GNU/Linux) After fetching data, the date was 1 month lesser than the current system date. Tested with SQL Query Analyzer the date was correct. If converted the date, was correct... "SELECT convert(varchar(50), getdate(), 102)" Best regards: Kecso Reproduce code: --------------- $r = mssql_query("SELECT getDate();"); print_r(mssql_fetch_Assoc($r)); Expected result: ---------------- " Array ( [computed] => 2006-08-18 17:07:05 ) " Actual result: -------------- " Array ( [computed] => 2006-07-18 17:07:05 ) " ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38502&edit=1