i have following query executed but no records fetched inspite of that in database there were record which full fill mention date criteria:
select * from vw_opdslip where opdate between 14/06/2015 and 16/06/2015
In my database there opdate field has datatype datetime and its format is set to shortdate.
Now how can i achieve this records using above query what modification will require there??