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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

sql_flagger_warning_level option [compatibility] Next Page

sr_date_format option [SQL Remote]

Sets the format for dates retrieved from the database.

Allowed values

String (composed of the symbols listed below)




The Message Agent uses this option when replicating columns that store a date. The format is a string using the following symbols:

Symbol Description
YY Two digit year
YYYY Four digit year
MM Two digit month)
MMM[m...] Character short form for months—as many characters as there are "m"s
DD Two digit day of month

Each symbol is substituted with the appropriate data for the date that is being formatted.

For symbols that represent character data (such as MMM), you can control the case of the output as follows:

If the character data is multibyte, the length of each symbol reflects the number of characters, not the number of bytes. For example, the 'mmm' symbol specifies a length of three characters for the month.

For symbols that represent numeric data, you can control zero-padding with the case of the symbols:

The option is a string build from the following symbols:

See also