Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Customizable Date Formats

Customizable Date Formats

You can customize the date format for partition names and the required format for dates supplied as parameters to functions or procedures.

The following function defines the date format used for naming the actual partitions in the database:

FUNCTION wgn_get_pn_date_fmt 
RETURN VARCHAR2;

By default, the wgn_partition_util package uses ‘yyyy/mm/dd’ dates (for example, 2007/01/31). This ensures that partitions are listed in chronological order in tools such as OEm or TOAD.

If you set a new date format, you must enclose it in single quotes.

The following function defines the date format for parameters supplied to functions and procedures in the package bodies for wgn_partition_util and wgn_partition_cust. You must enter dates in the correct format.

FUNCTION wgn_get_ip_date_fmt 
RETURN VARCHAR2;

By default, the wgn_partition_util package requires that you use ‘dd-mmm-yyyy’ dates (for example, 01-jan-2011), regardless of how the local system is configured to display dates.

If required, you can reset this to, for example, 'mmm-dd-yyyy'. If you set a new date format, you must enclose it in single quotes.