2 Replies Latest reply: Jul 26, 2012 4:21 AM by Rod West RSS

    Default Date Mask

    943508
      Hi All,

      We have about 15 business areas with 100+ folders each. Does anyone know how we can change the default date mask without going into every single folder and changing it for every date item?

      Thank you,
      MIS
        • 1. Re: Default Date Mask
          Srini Chavali-Oracle
          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 help

          How To Control the Date Format In Discoverer Plus/Viewer ? [ID 368230.1]

          HTH
          Srini
          • 2. Re: Default Date Mask
            Rod West
            Hi,

            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'
            Rod West