Using time display formats – PB Docs 150

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 15.0
  5. Using time display formats – PB Docs 150

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.

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

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
Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 15.0
and Functions Events Objects and Controls PB Docs 150 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 15.0 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 15.0 PowerDesigner Integration System Object Properties Using the ADO.NET Interface
August 20, 2023
Was this article helpful?
2
0
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x