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