Hi Sounds great - thanks a lot.
On Nov 10, 8:27 pm, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > > I am using h2 to do my unit testing. Unfortunately I have run into a > > problem when using the datediff function. My production database is > > Microsoft SQL server. The signature for the datediff function is not > > the same when using h2 compared to using mssql. When using h2 the > > units should be specified as a String but when using mssql the units > > should be specified using a constant such as day, month, year and so > > on (same as in h2 but not as a string). I have tried to enable the > > mssqlserver mode without any luck. > > Does anyone have a suggestion / solution to overcome this issue? > > I will implement the alternative MS SQL Server syntax in the next > release. The only thing that will not work is QUARTER/QQ/Q > (java.util.Calendar doesn't support it). I hope this works. > > Regards, > Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
