The mainframe date and time data types are date, time and timestamp. Date has a range from 0001-01-01 to 9999-12-31. Time has a range from 00:00:00 to 23:59:59. The special value 24:00:00 is equivalent to 24:00:00. The range of datetime is 1-1-1 00:00:00.000000 to 9999-12-31 23:59:59.999999.
Character string representation of date values
| Format Name
|
Abbreviation
|
Date Format
|
Example
|
| International Standards Organization
|
ISO
|
yyyy-mm-dd
|
1987-10-12
|
| IBM USA Standard
|
USA
|
mm/dd/yyyy
|
10/12/1987
|
| IBM European Standard
|
EUR
|
dd.mm.yyyy
|
12.10.1987
|
| Japanese industrial standard Christian era
|
JES
|
yyyy-mm-dd
|
1987-10-12
|
| Installation-defined
|
LOCAL
|
|
|
Character string representation of TIME values
| Format Name
|
Abbreviation
|
Date Format
|
Example
|
| International Standards Organization
|
ISO
|
hh.mm.ss
|
13.30.05
|
| IBM USA Standard
|
USA
|
hh:mm AM or PM
|
1:30 PM
|
| IBM European Standard
|
EUR
|
hh.mm.ss
|
13.30.05
|
| Japanese industrial standard Christian era
|
JES
|
hh:mm:ss
|
13:30:05
|
| Installation-defined
|
LOCAL
|
|
|
Character string representation of timestamp values
The default format is yyyy-mm-dd-hh-hh.mm.ss.nnnnnn.
The ODBC format is also accepted; this is yyyy-mm-dd hh:mm:ss.nnnnnn.
