The Microsoft .NET ODBC driver is version 1.0.0.3328
Regards Erik Hjortsberg Varchar AB
From: "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> To: "'Test Test'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: Timestamp to DateTime conversion in C# (.net) Date: Mon, 17 Mar 2003 10:02:57 +0100
Hi Erik
Which ODBC driver (release and version) do you use?
Regards Thomas
---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin
SAP DB is open source. Get it! www.sapdb.org
> -----Original Message----- > From: Test Test [mailto:[EMAIL PROTECTED] > Sent: Freitag, 14. M�rz 2003 20:46 > To: [EMAIL PROTECTED] > Subject: Timestamp to DateTime conversion in C# (.net) > > > I'm using sapdb over ODBC in C#(.net) and I'm having problems with > timestamps and the DateTime class. > All timestamps are converted to DateTime instances automatically. The > problem is that while the class DateTime only has a precision of > milliseconds (three digits) sapdb allows for six digits precision. > Now, a value such as "2001-10-01 02:01:03.123000" in sapdb should be > translated to "2001-10-01 02:01:03.123" in C# (with its > lesser precision). > But instead it's translated into "2001-10-01 02:01:03.000", > which is wrong. > This problem is however only related to the return values of > a query. When > inserting values a DateTime will be correctly translated > (i.e. padding the > millisecond value with "000"). > Does anyone know why this is and how to correct it? > > Erik Hjortsberg > Varchar AB > > _________________________________________________________________ > Skaffa fler messengerkontakter - Vinn 10.000 i resecheckar! > http://messenger.msn.se/promo > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general >
_________________________________________________________________
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
