Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

Materialized View Properties window: Options tab

This tab has the following components:

  • This materialized view was created with the following option settings:   Lists the options that were set when the materialized view was created.

Option Description
date_format

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

date_order

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

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.

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.

nearest_century

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

precision

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

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.

time_format

Sets the format for times retrieved from the database. The default is HH:NN:SS.SSS. See time_format option.

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.

timestamp_with_time_zone_format

Returns the format for TIMESTAMP WITH TIME ZONE values retrieved from the database. See timestamp_with_time_zone_format option.