Introduction to PowerBuilder

HomePrevious Lesson: Format Styles
Next Lesson: Edit Styles

Date and Time Formats

For date and time data types, there are an extra set of formats that can be used to display the data. The following table lists these extra formats:

Symbol

Date type

Time Type

Meaning

d

X

 

Day as a number.

dd

X

 

Day as a number with leading zero.

ddd

X

 

Day name abbreviation.

dddd

X

 

Full day name.

m

X

 

Month as a number.

mm

X

 

Month as a number with a leading zero.

mmm

X

 

Month name abbreviation.

mmmm

X

 

Full month name.

yy

X

 

Two digit year.

yyyy

X

 

Four digit year.

h

 

X

Hour.

hh

 

X

Hour with leading zero.

m

 

X

Minutes.

mm

 

X

Minutes with leading zero.

s

 

X

Seconds.

ss

 

X

Seconds with leading zero.

ffffff

 

X

Microseconds.

AM/PM

 

X

Displays AM or PM as applicable.

am/pm

 

X

Displays am or pm as applicable.

A/P

 

X

Displays A or P as applicable.

a/p

 

X

Displays a or p as applicable.

Again, check PowerBuilder's on-line help for more information.
HomePrevious Lesson: Format Styles
Next Lesson: Edit Styles