Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Create Database Partitions › Required Date Format

Required Date Format

When specifying date ranges in the wgn_partition_util partitioning package, you must enter dates in the correct format. By default, you must use this format:

'dd-mon-yyyy'

You must use this format even if the local system uses American dates (mon-dd-yyyy). Alternatively, you can customize the required format. But for all formats, you must enclose the date in single quotes.