Specifies the format to use when inserting date or time data into character columns.
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.
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. |