Re: Problem with TO_CHAR(timestamp, 'DD.MM.YYYY HH24:MI') --> ORA-01722

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 17 May 2003 17:57:23 +0100
Message-ID: <3ec66f64_2@mk-nntp-1.news.uk.worldonline.com>

"Peter Elsen" <p.elsen_at_kreis-dueren.de> wrote in message news:955858ba.0305170210.51742686_at_posting.google.com...
> Hello,
>
> my Internet-Provider has changed the Oracle DB to Version 8.1.7.
> Since this update I got an ORA-01722-Error when using this statement:
>
> SELECT TO_CHAR(timestamp, 'DD.MM.YYYY HH24:MI') FROM UMFRAGE;
> --> ORA-01722: Ungültige Zahl [= invalid number]
>
> The datefield 'timestamp' contains a trigger-generated SYSDATE.
>
> I tried to use TO_DATE(...) instead of TO_CHAR: I resolve only Day,
> Month and Year, but no time-information (hours and minutes).
>
> What can I do to resolve the complete date- and timeinformation ?
>
> Thank You!
>
> Peter

I bet "timestamp" is not really a date column...

in SQL*Plus,
desc umfrage

Regards,
Paul Received on Sat May 17 2003 - 11:57:23 CDT