Hi, get the latest PHP4 and set set php.ini-param mssql.datetimeconvert to Off
the the MSSQL-Module then returns datetime-values in this format: YYYY-MM-DD HH24:MI:SS bye, Benjamin Walling wrote: > I can't seem to find a way to format the field that comes back from my > DateTime fields in MSSQL Server. For example, '2002-05-13' shows in > Query > Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13 > 2002 12:00AM. date() won't take it. strftime() won't take it. What > do I > need to do to convert this to a time PHP likes? > > > -- -------------------------------------- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at --------- privat ----------- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -------------------------------------- "...the number of UNIX installations has grown to 10, with more expected..." - Dennis Ritchie and Ken Thompson, June 1972 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php