DB2 Date and Time formats for Software developers

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
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.

Advertisements

Author: Srini

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