Sybase Adaptive Server Anywhere - Page 201

Chapter 5 Database Options
183
DATE_FORMAT SELECT CURRENT DATE
yyyy/mm/dd/ddd 1998/05/21/thu
Jjj 141
mmm yyyy may 1998
mm-yyyy 05-1998
DATE_ORDER option
Controls the interpretation of date formats.
’M DY’, ’YMD ’, or ’DM Y ’
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
YMD. This corresponds to ISO date format specifications.
For Open Client and JDBC connections, the default is set to MDY.
The database option DATE_ORDER is used to determine whether 10/11/12
is Oct 11 1912, Nov 12 1910, or Nov 10 1912. The option can have the value
’M DY’, ’YMD ’, or ’DM Y ’.
DEFAULT_TIMESTAMP_INCREMENT option
Specifies the number of microseconds to add to a column of type
TIMESTAMP in order to keep values in the column unique.
Integer
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
1
Since a TIMESTAMP value is precise to six decimal places in Adaptive
Server Anywhere, by default 1 microsecond (0.000001 of a second) is added
to differentiate between two identical TIMESTAMP values.
Some software, such as Microsoft Access, truncates TIMESTAMP values to
three decimal places, making valid comparisons a problem. You can set the
TRUNCATE_TIMESTAMP_VALUES option to ON to specify the number
of decimal place values Adaptive Server Anywhere stores to maintain
compatibility.
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description