Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2000071

[PHP] MSSQL PHP4pl2 Truncates Dates From: Flint Doungchak (Flint <email protected>)
Date: 07/15/00

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 <email protected>
www.netsolutionsllc.com 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>