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 -~----------~----~----~----~------~----~------~--~---
