I just committed a fix for NH-2914 from cremor, which implements support for the hour(), minute() and second() functions in Oracle also for the DATE type. This also allows use of e.g. datetime.Hour etc. in LINQ.
Oracle's DATE type apparently can also store time information. Perhaps in a too hasty move, I suggested that the test cases should be allowed for all dialects. However the tests now fail on several dialect, since they don't allow the corresponding SQL features on DATE columns, since e.g. MSSQL doesn't store time information. For now, I'll just disable the tests for anything but Oracle again, since it's most relevant there. However, it got me thinking: Show we make hour() et.al. simply return 0 if they are used on a datetime property which is mapped to a sql type that doesn't contain time information? /Oskar
