Was this helpful?
II_DATE_FORMAT
Valid on Windows, Linux
The II_DATE_FORMAT parameter defines the format used to display date values.
The following are valid II_DATE_FORMAT settings and their output formats:
Setting
Output Format
US (default)
dd-mm-yyyy
MULTINATIONAL
dd/mm/yy
MULTINATIONAL4
dd/mm/yyyy
ISO
yymmdd
ISO4
yyyymmdd
ISO4T
yyyymmdd unless the date includes a time, in which case the format is: yyyymmddThhmmss
ISO4TC
yyyymmdd unless the date includes a time, in which case the format is: yyyymmddThh:mm:ss
SWEDEN or FINLAND
yyyy-mm-dd
GERMAN
dd.mm.yy
YMD
yyyy-mmm-dd
DMY
dd-mmm-yyyy
MDY
mmm-dd-yyyy
For valid input formats, see the SQL Reference Guide.
Last modified date: 01/30/2023