Formats supported by the standards

On the Options tab,you selected a Standard for the generate SQL to follow. However, some of the format values that are used to format time, dates, and literal constants are compatible with the standards. If you continually get an error message, indicating that you are selecting a Standards option that is not compatible with your format settings, you might considermodifiying the format information provided by your data source. For more information, see Setting up your JDBC connection.

ANSI/ISO Standard

Naming convention:

SQL naming convention

Decimal separator:

. (period)

Time format:

hh.mm.ss (*ISO)

Date format:

yyyy-mm-dd (*ISO)

DB2 family Standard

Naming convention:

SQL naming convention

Decimal separator:

. (period)

Time format:

hh.mm.ss (*ISO)
hh:mm AM/PM (*USA)
hh.mm.ss (*EUR)
hh:mm:ss (*JIS)

Date format:

yyyy-mm-dd (*ISO)
mm/dd/yyyy (*USA)
dd.mm.yyyy (*EUR)
yyyy-mm-dd (*JIS)


DB2 family with extensions

Naming convention:

SQL naming convention
System naming convention

Decimal separator:

. (period)
, (comma)

Time format:

hh.mm.ss (*ISO)
hh.mm.ss (*EUR)
hh:mm:ss (*JIS)
hh:mm AM/PM (*USA)
hh:mm:ss (*HMS)

Date format:

yyy-mm-dd (*ISO)
dd.mm.yyy (*EUR)
yyy-mm-dd (*JIS)
mm/dd/yyyy (*USA)
mm/dd/yy (*MDY)
dd/mm/yy (*DMY)
yy/mm/dd (*YMD)
yy/ddd (*JUL)