Joey Smith wrote:
Michael: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.
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?
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).2) This parameter doesn't appear to have any effect on the way FreeTDS returns dates from MSSQL. Can you confirm/deny that?
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 - [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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
-- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php