Convert timestamp to date

Trying to convert timestamp data to date data (without the time in hours/mins/secs), does only seem to work with TO_DATE(mydate; 'yyyymmdd').

But I do not want a string, but a real date like 29-03-2005.

How do I get it like that?

Thanks,
Bob Received on Tue Mar 29 2005 - 11:41:12 CST