This content has been marked as final. Show 2 replies
Pl post details of Discoverer, OS and database versions. I do not believe there is a universal option to control this. Pl see if this MOS Doc can help1 person found this helpful
How To Control the Date Format In Discoverer Plus/Viewer ? [ID 368230.1]
Hi,1 person found this helpful
I think the only way to do this is to hack the EUL table using SQL*Plus. Fine if you backup and know what you are doing, but otherwise a recipe for disaster.
The table you want to change is EUL5_EXPRESSIONS, so for example, to change the default date mask for all audit date columns (item name begining with Audit) from DD-MON-RRRR to DD-Month-YYYY you can use this SQL:
update eul5_expressions set it_format_mask = 'fmDD-Month-YYYY' where exp_type = 'CO' and exp_data_type = 4 and exp_name like 'Audit%' and it_format_mask = 'DD-MON-RRRR'