date_format   Sets the format for dates retrieved from the database. The default is YYYY-MM-DD. See date_format option [compatibility].

date_order   Controls the interpretation of date formats. The default is YMD. For Open Client and jConnect connections, the default is set to MDY See date_order option [compatibility].

default_timestamp_increment   Specifies the number of microseconds to add to a column of type TIMESTAMP to keep values in the column unique. The default is 1. See default_timestamp_increment option [database] [MobiLink client].

first_day_of_week   Sets the numbering of the days of the week. The default is 7 (Sunday is the first day of the week). See first_day_of_week option [database].

nearest_century   Controls the interpretation of two-digit years in string-to-date conversions. The default is 50. See nearest_century option [compatibility].

precision   Specifies the maximum number of digits in the result of any decimal arithmetic. The default is 30. See precision option [database].

scale   Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision. The default is 6. See scale option [database].

time_format   Sets the format for times retrieved from the database. The default is HH:NN:SS.sss. See time_format option [compatibility].

timestamp_format   Sets the format for timestamps that are retrieved from the database. The default is YYYY-MM-DD HH:NN:SS.SSS. See timestamp_format option [compatibility].