Bug #12655 Updated: date-format problem

ID: 12655 Updated by: steved@mad.scientist.com Reported By: thomas.winkler@jawa.at Status: Open Bug Type: MSSQL related Operating System: Win2k PHP Version: 4.0.6 New Comment: Same problem. I need access to at least the Seconds fields as we are processing telephone billing records. Hard to bill to the seconds when you can only query minutes. Will probably have to go back to ODBC db driver, or look at making a custom patch in my PHP_MSSQL.dll. Steve Dillon Previous Comments: ------------------------------------------------------------------------ [2001-08-08 12:02:35] thomas.winkler@jawa.at webserver: IIS5 (Win2k) php-version: php4.0.6 (CGI) db-server: MS SQL Server 2000 I've run into problems when fetching fields of type datetime from the database. When using the MS SQL Query Analyzer I get the dates formated like this out of the database: 2001-06-08 08:14:40.000 When using php to send my queries (mssql_query) to the database I get the dates formated like this: 08 06 2001 8:14 In my application I'd need the same format as i get it in the Query-Analyzer. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=12655&edit=1