Sets the format for times retrieved from the database.
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:
|HH||Two digit hours (24-hour clock).|
|NN||Two digit minutes.|
|MM||Two-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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|