User-defined formats
General syntax
A user-defined format is described by a sequence of special characters.
Arbitrary characters specified before and after the format strings will be printed as is.
To prevent the interpretation of a special character, you have to quote it with the
\ character.
Format syntax for a numeric expression
+
Print the sign of the number.
-
Print the sign of the number only if it is negative.
#
Print a digit only if necessary.
The number is left-padded with spaces so that the number of printed characters
before the decimal point is greater or equal than the number of # before the decimal point.
0
Always print a digit, padding with a zero if necessary.
.
Print the decimal separator.
,
Print the thousand separators.
%
Multiply the number by 100 and print a per-cent sign.
E
Introduces the exponential part of a
Float number. The sign of the exponent is always printed.
Examples
PRINT Format$(Pi, "-#.###")
PRINT Format$(Pi, "+0#.###0")
PRINT Format$(Pi / 10, "###.# %")
PRINT Format$(-11 ^ 11, "#.##E##")
Format syntax for currencies
To format currencies, you can use all numeric format characters, and the following ones:
$
Print the national currency symbol.
$$
When the $ is doubled, the international currency symbol is printed instead.
(
Print the representation of negative currencies. This must be the first character of the format. You can specify a closed brace ) at the end of the format.
Examples
PRINT Format$(1972.06, "$#.###")
PRINT Format$(-1972.06, ",ドル#.###")
PRINT Format$(-1972.06, "($,ドル#.###)")
Format syntax for dates
yy
Print the year on two digits.
yyyy
Print the year on four digits.
m
Print the month.
mm
Print the month on two digits.
mmm
Print the month in an abbreviated localized string form.
mmmm
Print the month in its full localized string form.
d
Print the day.
dd
Print the day on two digits.
ddd
Print the week day in an abbreviated localized form.
dddd
Print the week day in its full localized form.
/
Print the date separator.
h
Print the hour.
hh
Print the hour on two digits.
n
Print the minutes.
nn
Print the minutes on two digits.
s
Print the seconds.
ss
Print the seconds on two digits.
:
Print the time separator.
u
Print a point and the milliseconds, if they are different from zero.
uu
Print a point and the milliseconds with three digits.
t
Print the timezone alphabetic abbreviation.
tt
Print the timezone in HHMM format.
AM/PM
Print the localized equivalent of AM or PM, according to the hour, and force the hour to be between 1 and 12.
Since Gambas 3, the u date format does not print a point anymore. You must add it explicitly in the format string.
Examples
PRINT Format$(Now, "mm/dd/yyyy hh:nn:ss.u")
PRINT Format$(Now, "mm/dd/yyyy hh:nn:ss.uu")
PRINT Format$(Now, "m/d/yy h:n:s")
PRINT Format$(Now, "ddd dd mmm yyyy")
PRINT Format$(Now, "dddd dd mmmm yyyy")
PRINT Format$(Now, "yyyy-mm-dd hh-nn-ss")
PRINT Format$(Now, "yyyy/mm/dd hh:nn:ss")
2006年04月29日 07-41-11
2006年04月29日 07:41:11