Sorry, for my bed english... help me

in hql - query used NullableDateTime type and exist compared date string.
example:

from a as a
where a.Date > ???

I have string contains date, what i can build query without typecast exception?

Queries can also take strings... So, if you have a string then use it.
One example:

Read the SQL documentation to see how the date should be presented...

I'm writing an Candidature Manager application which can use a SQL Server or Firebird database to store the datas.

I want to write an HQL query which search for a Candidature list which have a date > A_DATE.

But I have some matter because of the difference between date format in
the 2 databases. Indeed, the date format are :
* SQL Server : 'dd/MM/yyyy'
* Firebird : 'MM/dd/yyyy'

So this HQL query is Ok with one database and thrown an exception with the other :


Is it possible to set change the date format of a database with NHibernate ?

Because I don't want to be forced to do something like this :

You should be able to build a parametrized query just fine. Use Nullables.NHibernate.NullablesTypes.NullableDateTime if you need an IType parameter to some call.

I had a similar problem one time: I had to use date on english and french systems (always with SQL Server); I had trouble to tell SQL Server which format to use and I finally found that YYYYMMDD is culture-independent (eg: 20050102 is always the 2th january 2005).

You may try this and see if it works on Firebird...

Yes KPixel,
I search on the web and found the ISO date format which is yyyymmdd but I think SQL Server 2000 don't recognize it anymore because I have the same problem.

So I changed the language of my login in SQL Server via the "sp_defaultlanguage" function of SQL Server.