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
