I'm trying to write a filter that compares a datetime field with another datetime value. Eventually I'd like to use a parameter but for now even comparisons with a constant fail.
Code:
@Filter(name = "datedversion", condition="(VALID_UNTIL is not null) and (VALID_UNTIL >=' 12.12.2009 00:00:00')")
hibernate replaces the : with :datedversion. which results in
Code:
a2bset0_.VALID_UNTIL >= '12.12.2009 00:datedversion.00:datedversion.00')
Then the database complains about not being able to convert to a datetime object. I am using MS SQL Server 2005 with german language settings.
Any ideas?
Login
FAQ
Search
