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.

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, 1).

hh

Hour with leading zero if appropriate (for example, 01).

m

Minute with no leading zero (must follow h or hh).

mm

Minute with leading zero if appropriate (must follow h or hh).

s

Second with no leading zero (must follow m or mm).

ss

Second with leading zero (must follow m or mm).

ffffff

Microseconds with no leading zeros. You can enter one to six f's; each f represents a fraction of a second (must follow s or ss).

AM/PM

Two-character, upper-case abbreviation (AM or PM as appropriate).

am/pm

Two-character, lower-case abbreviation (am or pm as appropriate).

A/P

One-character, upper-case abbreviation (A or P as appropriate).

a/p

One-character, lower-case abbreviation (a or p as appropriate).


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