Sets the format for times retrieved from the database.
String (composed of the symbols listed below)
HH:NN:SS.SSSSS
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. |
| 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.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |