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.

**Table 4-8: Special characters 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

Example 4

The following table shows how the time 9:45:33:234567 PM displays when different format masks are applied.

**Table 4-9: Time format examples**
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`