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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


time_format option [compatibility]

Sets the format for times retrieved from the database.

Allowed values

String (composed of the symbols listed below)




Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.


The format is a string using the following symbols:

Symbol Description
HH Two digit hours
NN Two digit minutes
SS.ssssss Seconds and fractions of a second, up to six decimal places. Not all platforms support timestamps to a precision of six places.
AA A.M. or P.M. (12 hour clock)—omit AA and PP for 24 hour time
PP PM if needed (12 hour clock)—omit AA and PP for 24 hour time

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.

See also