Question: Need to get the Data based on Date
I am having a criteria where i need to get the data based on date . I have written the query as "from Balance as b where b.date like ?"
But the date field in DB is in datetime2 format and has values as 2011-01-10 11:14:36.000000 . But i am getting the date from my controller as in format 2011-01-10 which is of type date . I want to exclude that time field and execute the query can any one please help as soon as possible.