Hi, Could you please send me a test.cs file to reproduce this bug ?
Regarding Odbc, You can either contact me or send your queries to the list. Thanks Nagappan Nagappan A <[EMAIL PROTECTED]> Linux Desktop Testing Project - http://ldtp.freedesktop.org http://nagappanal.blogspot.com Novell, Inc. SUSE* Linux Enterprise 10 Your Linux is ready* http://www.novell.com/linux >>> On Thu, May 3, 2007 at 11:27 AM, in message <[EMAIL PROTECTED]>, Mads Bondo Dydensborg <[EMAIL PROTECTED]> wrote: > mandag 30 april 2007 13:23 skrev Mads Bondo Dydensborg: >> tirsdag 24 april 2007 08:36 skrev Mads Bondo Dydensborg: >> > Hi there >> >> Hi again. >> >> Just a repost - does nobody know anything about these issues? > > And another one :- ) > > Is there a person doing the ODBC work, that I should talk directly to? > > Regards, > > Mads > >> >> Regards, >> >> Mads >> >> > >> > I am using Linux/Mono to access a Sybase ASA server (on Windows), using >> > Unixodbc (and possibly FreeTDS - I am actually not quite sure). >> > >> > Most things appear to work fine, however, when retrieving >> DateTimes/Timestamps >> > from the sybase server, it seems that it returns the fractional value of a >> > second, as _billonths_ of a second. Mono appears to expect this in >> > milliseconds: >> > >> > ENTER: System.DateTime:.ctor (int,int,int,int,int,int,int) > (value:0xbf8b53b0, >> > 2007, 4 >> > , 17, 14, 10, 50, 340000000, ) >> > . ENTER: System.DateTime:DaysInMonth (int,int)(2007, 4, ) >> > . . ENTER: System.DateTime:IsLeapYear (int)(2007, ) >> > . . LEAVE: System.DateTime:IsLeapYear (int)FALSE >> > . LEAVE: System.DateTime:DaysInMonth (int,int)result=30 >> > EXCEPTION handling: ArgumentOutOfRangeException >> > >> > The value 340000000 should be in milliseconds (says DateTime constructor), >> but >> > apperantly is in billionths of a second (nanoseconds, says ODBC). >> > >> > Looking at OdbcDataReader.GetValue, I find the following code: >> > >> > case OdbcType.Timestamp: >> > case OdbcType.DateTime: >> > case OdbcType.Date: >> > case OdbcType.Time: >> > OdbcTimestamp ts_data = new OdbcTimestamp(); >> > ret = libodbc.SQLGetData (hstmt, ColIndex, col.SqlCType, ref ts_data, > 0, >> > ref outsize); >> > if (outsize!=- 1) // This means SQL_NULL_DATA >> > DataValue = new >> > DateTime(ts_data.year,ts_data.month,ts_data.day,ts_data.hour, >> > ts_data.minute,ts_data.second,Convert.ToInt32(ts_data.fraction)); >> > break; >> > >> > OdbcTimestamp.fraction is declared as a long. SQLGetData is an extern >> method - >> > looks like it is just supposed to fill in the binary values? I find it a > bit >> > puzzling, perhaps even suspiciuos, that ts_data.fraction is converted to > an >> > int 32 from a long in the call to DateTime - disregarding (perhaps?) the >> > scale of the fraction? >> > >> > I am a bit confused about this. Before looking into it further, I would >> > appreciate a comment on wheter this could potentially be a bug in the Mono >> > ODBC stack? Also, where values are "set", that is, if wanting to update a >> > timestamp from mono - where the conversion takes place (there are quite > many >> > Odbc related files :- ). >> > >> > The same code runs without problems under Windows/MS. Of course, that is > not >> > to say it is correct, only that the data returned is as expected. >> > >> > Regards, >> > >> > Mads >> > >> > -- >> > Med venlig hilsen/Regards >> > >> > Systemudvikler/Systemsdeveloper cand.scient.dat, Ph.d., Mads Bondo >> Dydensborg >> > Dansk BiblioteksCenter A/S, Tempovej 7- 11, 2750 Ballerup, Tlf. +45 44 86 > 77 >> 34 >> > _______________________________________________ >> > Mono- devel- list mailing list >> > Mono- devel- [EMAIL PROTECTED] >> > http://lists.ximian.com/mailman/listinfo/mono- devel- list >> > >> > >> >> -- >> Med venlig hilsen/Regards >> >> Systemudvikler/Systemsdeveloper cand.scient.dat, Ph.d., Mads Bondo > Dydensborg >> Dansk BiblioteksCenter A/S, Tempovej 7- 11, 2750 Ballerup, Tlf. +45 44 86 77 > 34 >> _______________________________________________ >> Mono- devel- list mailing list >> Mono- devel- [EMAIL PROTECTED] >> http://lists.ximian.com/mailman/listinfo/mono- devel- list >> >> _______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list