OS Dec Alpha OSF/1 V3.0
Does anyone know how to keep the default date format (dd-mon-yy) for a field,
but handle the cenutury change?
Oracle gives us 'RR' to do the conversion, but I can't figure out where
to use it to make this thing work.
The 'RR' part of the format will convert 00-49 to the next century and leave
50-99 in the current.
Things we have tried that have failed:
- Change NLS_DATE_FORMAT to DD-MON-RR in the init.ora file
This doesn't work, and keeps sqlmenu50 designer from working.
- Put DD-MON-RR in the format mask for the date field.
This gives an error: "FRM-40209 Field must be of form DD-MON-RR"
Duhh... I entered 12-MAY-09! What are they looking for?
- Create a database trigger to modify the 'NEW:' value with the 'RR'
conversion.
Upon commiting the row, forms complains that another user has modified
your row and you should requery.
We are not about to go through the kludge of creating non-db fields for all
the applications.