What format do you want? You can use select convert(char(10),date_field,101) and you will get mm/dd/YYYY, or look at the convert function in the SQL Server Books Online, or u can use php function date and format whatever you want. Radovan "Matt Brown" <matt@ispsolutions.co.uk> wrote in message MOEHKANCAIEPPJENOOJOOEDOCGAA.matt@ispsolutions.co.uk">news:MOEHKANCAIEPPJENOOJOOEDOCGAA.matt@ispsolutions.co.uk... > Hi All, > > We have MS Sql Server 7 running backend and are running our reports via > PHP 4.2.3 (compiled with freetds), we have the flag > mssql.datetimeconvert = 0 set in the php.ini, but yet all date/time(s) > are returned as 'Nov 13 2002 02:26PM'... > > This is driving us mad, everywhere we search for a solution says that > the flag mssql.datetimeconvert = 0 or Off fixes this problem, however in > our config it does not ... > > Anyone have any suggestions ? > > Regards > > Matt Brown > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.417 / Virus Database: 233 - Release Date: 08/11/2002 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
