Skip to Content.
Sympa Menu

freetds - Re: [freetds] Dates are returned by freetds with the month -1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Claude Renglet <c.renglet AT nirond.be>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Dates are returned by freetds with the month -1
  • Date: Thu, 02 Jun 2005 08:16:37 +0200

Thanks Carlo,

I've updated my php from 4.3.6 to 4.3.11, and everything comes back as normal.

Thanks again for your answers

Carlo Simeone wrote:

Il mer, 2005-06-01 alle 16:00, Claude Renglet ha scritto:

thanks,

I've didn't though these tests.
Now I've did it, I'm more confused.

from tsql command processor, everything perfect, dates are returned correctly either from getdate() or from table data.
but from php, I've got the dates returned with the month - 1 yet, even with getdate()



Try with a newer PHP/FreeTDS version. I don't remember well when/where
this problem was corrected....
If you can't change it, try the follwing mini-patch:

On "etx/mssql/php_mssql.c" put after both the sprintf lines:

(sprintf(res_buf, "%d-%02d-%02d %02d:%02d:%02d" , dateinfo.year,
dateinfo.month, dateinfo.day,dateinfo.hour, dateinfo.minute,
dateinfo.second);

this code:

#if HAVE_FREETDS
dateinfo.month++;
#endif

and

#if HAVE_FREETDS
dateinfo.month++;
#endif

Then, rebuild PHP.

HTH






Archive powered by MHonArc 2.6.24.

Top of Page