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

sr_date_format option [SQL Remote] Next Page

sr_time_format option [SQL Remote]

Sets the format for times 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 time. The format is a string using the following symbols:

Symbol Description
HH Two digit hours (24-hour clock).
NN Two digit minutes.
MMTwo-digit minutes if following a colon (as in hh:mm).
SS.ssssss Seconds and fractions of a second, up to six decimal places. Not all platforms support timestamps to a precision of six places.

Each symbol is substituted with the appropriate data for the time that is being formatted. Any format symbol that represents character rather than digit output can be put in uppercase, which causes the substituted characters to also be in uppercase. For numbers, using mixed case in the format string suppresses leading zeros.


Using mixed case in the formatting string suppresses leading zeroes.

See also