mssql hibernatecritera fetch date from datetime database code example Example: sql datetime as date SELECT CONVERT(DATE, GETDATE()) date;