Convert timestamp to date

[Bob]

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

[Walt]

Bob wrote:

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?

1) try the trunc function, i.e. "select trunc(sysdate) from dual;"

2) try re-converting your string back to a date, i.e.
"select to_date(to_char(mydate,fmt1),fmt2) from dual;"
using appropriate format strings for fmt1 and fmt2.

3) Or maybe I don't really understand what you're trying to do. What do
you mean by "timestamp data" as opposed to "date data"?

--
//-Walt
//
//