DateStyle option
Specifies how to interpret the date format.
The possible values for the DateStyle option
are shown in the following
table. The example shows how the date 21 March 2014 would be represented
without a date
delimiter.
| Value | Description | Example |
|---|---|---|
| YMD | Four-digit year, two-digit month, two-digit day. This is the default. | 20140321 |
| DMY | Two-digit day, two-digit month, four-digit year. | 21032014 |
| MDY | Two-digit month, two-digit day, four-digit year. | 03212014 |
| MONDY | Three-character month, two-digit day, four-digit year. | Mar212014 |
| DMONY | Two-digit day, three-character month, four-digit year. | 21Mar2014 |
| Y2MD | Two-digit year, two-digit month, two-digit day. This value is not supported for unloads. | 140321 |
| DMY2 | Two-digit day, two-digit month, two-digit year. This value is not supported for unloads. | 210314 |
| MDY2 | Two-digit month, two-digit day, two-digit year. This value is not supported for unloads. | 032114 |
| MONDY2 | Three-character month, two-digit day, two-digit year. This value is not supported for unloads. | Mar2114 |
| DMONY2 | Two-digit day, three-character month, two-digit year. This value is not supported for unloads. | 21Mar14 |
The four-digit years are in the range 0001 - 9999. There is no provision for years before 0001 CE or after 9999 CE.
Examples follow:
- In a control file, to specify the date format MM-DD-YY (for example, 03-21-14), set the DateStyle option to MDY2 and the DateDelim option to '-'.
- A jan-01.data data file contains records in
the following format (the date
format is shown in
bold):
Because the date value uses the DD/MM/YYYY format, you can load that file by specifying the following nzload command:14255932|30/06/2002|20238|20127|40662|157|nzload -t agg_month -df jan-01.data -delim '|' -dateStyle DMY -dateDelim '/'