Can't you do the select as
select to_date(xxx) from timesheetdate where mydate between (yyy) and (zzz).
Or some syntax like that?