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.

5 Top Data warehousing Skills in the age of Big data and Analytics http://t.co/oYjpD79EPi #datawarehousing

— ApplyBigAnalytics (@applyanalytics) August 21, 2015

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.