MSSQL PHP4pl2 Truncates Dates

From: Date: Sat, 15 Jul 2000 22:03:40 +0000
Subject: MSSQL PHP4pl2 Truncates Dates
Groups: php.windows 
Request: Send a blank email to php-windows+get-1107@lists.php.net to get a copy of this message
Hello, I recent installed PHP4 pl2 on IIS4 on SP6a. I'm connecting to a MSSQL 7.0 SP2 database and everything seems to be working well (i.e. i can connect and all that). However, when I select a date column, PHP, or MSSQL, truncates the date. For instanace '2000-07-10 00:00:00.000' (as reported by Query Analyzer) in MSSQL gets passed to PHP as 'Jul 10 2'. Yes, that's a 2 with no zeros after it. I've tried converting the date, but that didn't work either (it just spits back the same thing). I'm new to MSSQL and miss some of the MySQL straightforwardness but need some of the features of MSSQL. Can some here enlighten me as always. Thanks in advance. -Flint ________________________________________________ Flint Doungchak Web Applications Development Net Solutions LLC 840 Lawrence Street Eugene, OR 97401 VOICE (541) 345-7087 FAX (541) 485-5519 flint@netsolutionsllc.com www.netsolutionsllc.com

« previous php.windows (#1107) next »