Hi,
Joey Smith wrote:
> Michael:
>
> Thanks for speaking up! I'd be glad to document this with your help. I
> have a few questions.
>
> 1) What is the format when this param is set to on?
its a weird format, sometimes I had the date-parts separated with spaces
and the time without seconds, I guess it depends on some language
settings, or the language of the installed windows.
> 2) This parameter doesn't appear to have any effect on the way
> FreeTDS returns dates from MSSQL. Can you confirm/deny that?
>
it also works if you have compiled the MSSQL extension against FreeTDS,
but currently there is a bug in the MSSQL extension when FreeTDS is
compiled for the sybase-ctlib (wich is the default), wich causes a wrong
month-value because the sybase-lib returns the month starting with 0
and the mssql-dblib with 1 (I submited already a patch for that to Frank
M. Kromann).
But I don't know the standard format of FreeTDS when converting
datetime-values.
However, I also saw a lot of bug-reports related this problem (weird
datetime-values), it would be good to write in the docu, that this
switch is a workaround for that problem.
bye,
--
------------------------------- -------------------------------------
Michael Bretterklieber - Michael.Bretterklieber@jawa.at
JAWA Management Software GmbH - http://www.jawa.at
Liebenauer Hauptstr. 200 -------------- privat ---------------
A-8041 GRAZ GSM: ++43-(0)676-93 96 698
Tel: ++43-(0)316-403274-12 E-mail: michael@bretterklieber.com
Fax: ++43-(0)316-403274-10 http://www.bretterklieber.com
------------------------------- -------------------------------------
"...the number of UNIX installations has grown to 10, with more
expected..." - Dennis Ritchie and Ken Thompson, June 1972