Wednesday, November 09, 2005
DDL issue for Oracle date formats in other locales
The DDL needed changing when installing PRS in Quebec because some column definitions included defaults for to_date(`30-dec-9999`,DD-MON-YYYY)
but in fact the month DEC is not valid for the French locale.
The DDL needs to be modified to make the defaults of the form: to_date(30-12-9999,DD-MM-YYYY)
but in fact the month DEC is not valid for the French locale.
The DDL needs to be modified to make the defaults of the form: to_date(30-12-9999,DD-MM-YYYY)
