|
Sets the format for times retrieved from the database.
UltraLite employs different methods for setting this property:
| Context | Implemented by |
|---|---|
|
From the command line Use any utility that creates a database. |
Use the following property syntax: -o time_format=value |
|
From Sybase Central Use any wizard that creates a database. |
On the New Database Options page, set the Time Format option. |
|
From a client application Use the create database method. |
Set this property as one of the creation parameters for an API's create database method on the database manager class. |
A string using any of 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[.s...] |
Two digit seconds plus optional fraction. |
HH:NN:SS.SSS
You cannot change the time format of an existing database. Instead, you must create a new database.
Each symbol is substituted with the appropriate data for the time that is being formatted.
Controlling zero-padding You can control zero-padding with the case of the symbols:
Type the symbol in same-case (such as HH or hh) to allow zero padding. For example, HH:NN:SS could produce 01:01:01.
Type the symbol in mixed case (such as Hh or hH) to suppress zero padding. For example, Hh:Nn:Ss could produce 1:1:1.
If a transaction was executed at 3:30 PM and you used the default time_format syntax of HH:NN:SS.SSS, the result would be:
15:30:55.0