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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.