Skip to Content.
Sympa Menu

freetds - [freetds] Problem with datetime from a MS SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Frank M. Kromann" <frank AT kromann.info>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Problem with datetime from a MS SQL Server
  • Date: Sun, 09 Feb 2003 14:54:34 -0800

Hi,

This problem is found when testing the MSSQL extension with FreeTDS on a
Linux box.

When fetching a datetime column I get two different results:

using dbconvert() I get 'Mar 17 2001 12:00AM'

using dbdatecrack() I get '2001-02-17 00:00:00'

Notice the difference in the Month. According to MS documentation the
month should be 1-12 and this works on Windows using the ntwdblib.lib.

The question is should dbdatecrack() be fixxed or should I hack teh PHP
extension ?

- Frank







Archive powered by MHonArc 2.6.24.

Top of Page