DB2 Date formats Tutorial unlock now

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.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.