'Oracle - export data to excel - column display error

There is a package which build excel report file. There is also a function which validates if value is date or something else. Part of code - main check:

enter image description here

But some numbers (ID's) when they are treated by to_date function - they also happen to be a date like in this example:

enter image description here

My date format is YYYY-MM-DD HH24:MI:SS, so this number is converted to string, and then like on the screen above. Then column in excel file is treated as dates, and it shows display errors.

How can I fix this? Note that report could be run on other NLS, so it should be universal.

Thanks.

sqlexceloracleplsqloracle18c


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions