Convert timestamp to date
From: Bob <no_at_mail.com>
Date: Tue, 29 Mar 2005 19:41:12 +0200
Message-ID: <171b5$42499338$52ad0338$20497_at_news.versatel.nl>
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').
Date: Tue, 29 Mar 2005 19:41:12 +0200
Message-ID: <171b5$42499338$52ad0338$20497_at_news.versatel.nl>
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 - 19:41:12 CEST