Im using localization in my application. When im running my application in local machine (which is having US("en-US") regional settings) application working fine without any issues.

If im running the same application in the server(which is having Spain("es-MX") regional settings) application throw the "out of range datetime" issue.

Please anyone give me idea to fix this issue.

If we are using normal sql we can use "set dateformat dmy;". But i dont know how to set this in nhibernate. Please help me to comeout of this error.

Finally its resolved by setting the type="DateTime" in the mapping file itself. If we are specifying the type for the date fields then the hibernate itself take care of the datetime format. Great Nhinernate :)