4 DB2 DATE Formats to Read Right now

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

Author: Srini

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