Don't return time stamp

1

I am trying to do a date between but I don't want to return the timestamp

2

is this in Cognos or sql server?

3

Its SQL

4 
select x,y,z
From ibm
where cast(datewithstamp as date) beweet @fromdate and @todate
5

Thank you