On Sun, Sep 14, 2008 at 4:57 AM, Ardekantur <[EMAIL PROTECTED]>wrote:
> > Hello all - Hi Matthew! I don't use an oracle database, but theoretically all Northwind schemas should be almost the same. Maybe there are some incoherences since scripts are made by hand. > > In addition, EXTRACT does not support retrieving milliseconds. Do you know another way to extract milliseconds from a datetime column? If so, it would be interesting to override the SqlProvider.GetLiteralDateDiff keeping in mind such peculiarity. Nonetheless I want to take a look to ReadTests_DateTimeFunctions.DateTimeDiffMilliseconds more detailedly since it is falling even in linq2sql, maybe the test is wrong, or maybe to get milliseconds from a datetime is not supported by Linq2Sql. It should be considered that if DbLinq wishes to keep these tests in > the project, they alter their Northwind DB to provide at least one > DATETIME column to test these methods on. We should keep rest of DateDiff tests, they work fine on Test_Nunit_Mssql_Strict (linq2sql) our reference, they also work on Mssql, and most of them on postgre. Therefore and IMO the oracle northwind-script should be modified to make it coherent regards rest of Northwind schemas, that is, adding such datetime columns. -- Saludos. Pablo Iñigo Blasco . --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
