THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
This solution is valid for the "ORA-01830: date format picture ends before converting entire input string" error too in Oracle 10g.
How to set the format of Dates
...