DB2 Date formats an important concept for SQL developers. Before they write SQL query, they should know the DATE format, so that they can avoid errors. DB2 supports four Date types – ISO, USA, EUR and JIS.
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.
