[freetds] Dates are returned by freetds with the month -1
Claude Renglet
c.renglet at nirond.be
Thu Jun 2 02:16:37 EDT 2005
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
>
>
>
More information about the FreeTDS
mailing list