freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Problem with datetime from a MS SQL Server
- 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
-
[freetds] Problem with datetime from a MS SQL Server,
Frank M. Kromann, 02/09/2003
- Re: [freetds] Problem with datetime from a MS SQL Server, James K. Lowden, 02/09/2003
- <Possible follow-up(s)>
-
RE: [freetds] Problem with datetime from a MS SQL Server,
Lowden, James K, 02/10/2003
-
Re: [freetds] Problem with datetime from a MS SQL Server,
Steve Langasek, 02/10/2003
- Re: [freetds] Problem with datetime from a MS SQL Server, Brian Bruns, 02/10/2003
-
Re: [freetds] Problem with datetime from a MS SQL Server,
James K. Lowden, 02/10/2003
-
Re: [freetds] Problem with datetime from a MS SQL Server,
Steve Langasek, 02/10/2003
- Re: [freetds] Problem with datetime from a MS SQL Server, James K. Lowden, 02/11/2003
-
Re: [freetds] Problem with datetime from a MS SQL Server,
Steve Langasek, 02/10/2003
-
Re: [freetds] Problem with datetime from a MS SQL Server,
Steve Langasek, 02/10/2003
- RE: [freetds] Problem with datetime from a MS SQL Server, ZIGLIO Frediano, 02/10/2003
- RE: [freetds] Problem with datetime from a MS SQL Server, ZIGLIO Frediano, 02/11/2003
- RE: [freetds] Problem with datetime from a MS SQL Server, Lowden, James K, 02/11/2003
Archive powered by MHonArc 2.6.24.