I noticed that, in some cases, i can create a DATE column with the TO_DATE('31/12/2049') default value (this date is in Italian format, so DD/MM/YYYY).
In some other cases, if i try to create a DATE column with this default value, it gives me the error ORA-01843: not a valid month; so, i need to specify the format, and if i insert the TO_DATE('31/12/2049','DD/MM/YYYY') default value, it runs correctly.
My question is: where this format is derived from? From the Oracle user of the session, from the owner of the object, from the session itself?
Thank you,
Sara