Using
time display formats
Applies to
Display formats
Description
A time display format can have two sections. The first section is
required and contains the format for times. The second section is optional
and specifies how to represent NULLs.
|
1 |
time-format;null-format |
The following table shows characters that have special meaning in
time display formats.
|
Character |
Meaning |
|---|---|
|
h |
Hour with no leading zero (for example, |
|
hh |
Hour with leading zero if appropriate (for example, |
|
m |
Minute with no leading zero (must follow h or |
|
mm |
Minute with leading zero if appropriate (must follow |
|
s |
Second with no leading zero (must follow m or |
|
ss |
Second with leading zero (must follow m or |
|
ffffff |
Microseconds with no leading zeros. You can enter one |
|
AM/PM |
Two-character, upper-case abbreviation (AM or PM as |
|
am/pm |
Two-character, lower-case abbreviation (am or pm as |
|
A/P |
One-character, upper-case abbreviation (A or P as |
|
a/p |
One-character, lower-case abbreviation (a or p as |
Colons, slashes, and spaces display as entered in the mask.
The keyword [Time] tells PowerBuilder to use the time format
specified in the Microsoft Windows control panel.
Usage
24-hour format is the default. Times display in 24-hour format
unless you specify AM/PM, am/pm, A/P, or a/p.
Examples
The following table shows how the time 9:45:33:234567 PM displays
when different format masks are applied.
|
Format |
Displays |
|---|---|
|
h:mm AM/PM |
9:45 PM |
|
hh:mm A/P |
09:45 P |
|
h:mm:ss am/pm |
9:45:33 pm |
|
h:mm |
21:45 |
|
h:mm:ss |
21:45:33 |
|
h:mm:ss:f |
21:45:33:2 |
|
h:mm:ss:fff |
21:45:33:234 |
|
h:mm:ss:ffffff |
21:45:33:234567 |
|
m/d/yy h:mm |
1/30/03 21:45 |