DB2 Version 9.7 for Linux, UNIX, and Windows

DateTimeStringFormat CLI/ODBC configuration keyword

Specifies the format to use when inserting date or time data into character columns.

db2cli.ini keyword syntax:: DateTimeStringFormat = JIS | ISO | EUR | USA
Default setting:: The JIS format is used when date or time data is inserted into character columns.
Usage notes:

The DateTimeStringFormat keyword controls the format in which date or time data is inserted into character columns. This setting affects the insertion of SQL_C_TYPE_DATE, SQL_C_TYPE_TIME, or SQL_C_TYPE_TIMESTAMP, or SQL_C_TIMESTAMP_EXT data into the following column types:

SQL_CHAR
SQL_VARCHAR
SQL_LONGVARCHAR
SQL_CLOB

This keyword also affects the format of date or time columns that are retrieved into character strings. For example, retrieving data from an SQL_TYPE_TIMESTAMP column into an SQL_C_CHAR string will be affected by the setting of this keyword.

The four setting values are as follows:

Format	Date	Time	Timestamp
JIS	yyyy-mm-dd	hh:mm:ss	yyyy-mm-dd hh:mm:ss.ffffffffffff
ISO	yyyy-mm-dd	hh.mm.ss	yyyy-mm-dd-hh.mm.ss.ffffffffffff
EUR	dd.mm.yyyy	hh.mm.ss	yyyy-mm-dd hh:mm:ss.ffffffffffff*
USA	mm/dd/yyyy	hh:mm AM or PM	yyyy-mm-dd hh:mm:ss.ffffffffffff*
*Timestamps will take the default format if EUR or USA is specified. The default format is JIS.