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.
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].
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|