compress field (date format)

[nampon]

Hi,

I am trying to do compress on DATE column.
Fortunatellly, I can define the column as below.

EVENT_DATE DATE format 'YYYY-MM-DD' NOT NULL compress(DATE '2001-03-31').

Here you will see that the DATE compress field is in YYYY-MM-DD format.
I wonder that is there a way that I can do the compression with DATE field in YYYYMMDD format?

Thank you for your help.
NB

 

[BillDHS]

Although I have not tried it, this may work:

EVENT_DATE DATE NOT NULL compress '20010331' (Date, Format 'yyyymmdd')

The format you have above is a display format, and does not define how the date is stored. It is always stored as an integer.

 

[nampon]

Thank you for your message. Unfortunatelly, I have tried what you suggested, but it still won't work.