Valid Format Keywords
The following table shows the keywords for valid formats, with a description and example of each.
Keyword
Description
Example(s)
MM
2-digit month
01, 02, 03, ..., 12
MMDD
2-digit month and 2-digit day
March 31 is 0331
MMDDYY
2-digit month, 2-digit day, and 2-digit year
March 31, 1970 is 033170
MMDDYYYY
2-digit month, 2-digit day, and 4-digit year
March 31, 1970 is 03311970
DELIM_M_D
Any delimited month followed by day
March 31, 3/31, or 03-31
DELIM_M_D_Y
Any delimited month, day, and year
March 31, 1970 or 3/31/70
DELIM_Y_M
Any delimited year followed by month
March, 70; 3-70; or 3/1970
DELIM_Y_M_D
Any delimited year, month, and day
1970 Mar 31 or 70/3/31
YYMMM
2-digit year and 3-letter month
70MAR
YYMMMDD
2-digit year, 3-letter month, and 2-digit day
70MAR31
YY
2-digit year
70
YYMM
2-digit year and 2-digit month
7003
YYMMDD
2-digit year, 2-digit month, and 2-digit day
700331
YYYYMMM
4-digit year and 3-letter month
1970MAR
YYYYMMMDD
4-digit year, 3-letter month, and 2-digit day
1970MAR31
YYYY
4-digit year
1970
YYYYMM
4-digit year and 2-digit month
197003
YYYYMMDD
4-digit year, 2-digit month, and 2-digit day
19700331
DELIM_M_Y
Any delimited month followed by year
3-70, 3/70, Mar 70, March 1970
DELIM_D_M
Any delimited day followed by month
31-3, 31/3, 31 March
DELIM_D_M_Y
Any delimited day, month, and year
31-MAR-70, 31/3/1970, 31 03 70
DD
2-digit day
31
DDMMM
2-digit day and 3-letter month
31MAR
DDMMMYY
2-digit day, 3-letter month, and 2-digit year
31MAR70
DDMMMYYYY
2-digit day, 3-letter month, and 4-digit year
31MAR1970
DDMM
2-digit day and 2-digit month
3103
DDMMYY
2-digit day, 2-digit month, and 2-digit year
310370
DDMMYYYY
2-digit day, 2-digit month, and 4-digit year
31031970
MMYY
2-digit month and 2-digit year
0370
MMYYYY
2-digit month and 4-digit year
031970
MMM
3-letter month
MAR
MMMDD
3-letter month and 2-digit day
MAR31
MMMDDYY
3-letter month, 2-digit day, and 2-digit year
MAR3170
MMMDDYYYY
3-letter month, 2-digit day, and 4-digit year
MAR311970
MMMYY
3-letter month and 2-digit year
MAR70
MMMYYYY
3-letter month and 4-digit year
MAR1970
MONTH
Month of the year
January, February, March, and so on or Jan, Feb, Mar, and so on
WEEKDAY
Day of the week
Sunday, Monday, Tuesday, and so on (Sunday = 0)
WKD
Abbreviated day of the week
Sun, Mon, Tues, and so on
(Sun = 0)
Copyright IBM Corporation 2015. All Rights Reserved.