Error during sorting over Oracle 12c timestamp-column

Avatar
  • updated
  • Completed

Hi anyone,

we get an error during sorting a query-result.
Out plattform is oracle 12c with AL32UTF8. Some table has columns with timestamp-typ. When I sorting the result over any other column, all working fine. When I sort a timestamp-column I get a error with "string (0.0) is invalid"

Can you analyse and fix it?

Best regards
Mat

Avatar
Mat

I find out thats a problem with our data...
Why SQL-Query throw an error is unclear.

 

I create a table with same structure and fill out example-data's. All working fine. But one table with costumer maked inputs are throw an error.

Avatar
Anonymous

Hello, Mat.

We'll be glad to investigate this issue having more information about this problem. Please send the necessary scripts to reproduce the problem via a private support request.