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

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 Received on Sat May 17 2003 - 05:10:39 CDT