| Home | Previous Lesson: Format Styles Next Lesson: Edit Styles |
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.
| Home | Previous Lesson: Format Styles Next Lesson: Edit Styles |