DB2 supports four Date formats. Those are ISO, USA, EUR and JIS. Knowing of these help you understand its meaning.

International Organization for Standardization (ISO)

YYYY-MM-DD
HH.MM.SS

IBM USA Standard (USA)

MM/DD/YYYY
HH:MM AM or PM

IBM European Standard (EUR)

DD.MM.YYYY
HH.MM.SS

Japanese Industrial Standard (JIS)

YYYY-MM-DD
HH:MM:SS

Site Specific (LOC)

Based on database territory and country code, For date formats, YYYY = Year, MM = Month, and DD = Day;

for time formats, HH = Hour, MM = Minute, and SS = Seconds.

Related