Formatos Fecha y hora
Throughout your 4D projects, you might need to format date and/or time values according to the specificities of the application, the platform, or the interface.
4D includes a comprehensive list of patterns that you can use to create and apply customized date and time formats in your applications, in addition to default formats. Customized format patterns are supported by the following features:
- the
String
command, - the
OBJECT SET FORMAT
andOBJECT Get format
commands, - the date and time format form object properties, available from the Property list or the
dateFormat
andtimeFormat
JSON properties.
Lista de patrones
The following table lists all supported patterns for date and time formats.
Símbolo | Significado | Modelo | Ejemplo de salida |
---|---|---|---|
G | designador de era | G, GG o GGG | AD |
GGGG | Anno Domini | ||
GGGGG | A | ||
y | año | yy | 96 |
y o yyyy | 1996 | ||
Y | año de "Semana del año" | Y | 1997 |
u | año prolongado | u | 4601 |
Q | trimestre | Q | 2 |
02 | |||
QQQ | Q2 | ||
QQQQ | 2do trimestre | ||
QQQQQ | 2 | ||
q | trimestre independiente | q | 2 |
02 | |||
qqq | Q2 | ||
qqqq | 2do trimestre | ||
qqqqq | 2 | ||
M | mes en año | M | 9 |
MM | 09 | ||
MMM | Sept | ||
MMMM | Septiembre | ||
MMMMM | S | ||
L | mes independiente en año | L | 9 |
LL | 09 | ||
LLL | Sept | ||
LLLL | Septiembre | ||
LLLLL | S | ||
w | semana del año | w | 27 |
ww | 27 | ||
d | día del mes | d | 2 |
dd | 2 | ||
D | día del año | D | 189 |
E | día de la semana | E, EE o EEE | Tue |
EEEE | Tuesday | ||
EEEEE | T | ||
EEEEEE | Tu | ||
e | local day of week | e | 2 |
ee | 02 | ||
eee | Tue | ||
eeee | Tuesday | ||
eeeee | T | ||
eeeeee | Tu | ||
c | stand-alone local day of week | c o cc | 2 |
ccc | Tue | ||
cccc | Tuesday | ||
ccccc | T | ||
cccccc | Tu | ||
a | AM o PM | a, aa, o aaa | PM [abbrev] |
aaaa | PM [wide] | ||
aaaaa | p | ||
b | AM, PM, mediodía, medianoche | b, bb o bbb | mid. |
bbbb | medianoche | ||
bbbbb | md | ||
B | flexible day periods | B, BB o BBB | at night [abbrev] |
BBBB | at night [wide] | ||
BBBBB | at night [narrow] | ||
h | hour in am/pm (1~12) | h | 7 |
hh | 07 | ||
H | hour in day (0~23) | H | 0 |
HH | 00 | ||
K | hour in am/pm (0~11) | K | 0 |
KK | 00 | ||
k | hour in day (1~24) | k | 24 |
kk | 24 | ||
m | minuto en hora | m | 4 |
mm | 04 | ||
s | segundo en minuto | s | 5 |
ss | 05 | ||
X | Time Zone: ISO8601 basic hm?, with Z for 0 | X | -08, +0530, Z |
Zona horaria: ISO8601 hm básico, con Z | XX | -0800, Z | |
Time Zone: ISO8601 extended hm, with Z | XXX | -08:00, Z | |
Time Zone: ISO8601 basic hms?, with Z | XXXX | -0800, -075258, Z | |
Time Zone: ISO8601 extended hms?, with Z | XXXXX | -08:00, -07:52:58, Z | |
x | Time Zone: ISO8601 basic hm?, without Z for 0 | x | -08, +0530 |
Time Zone: ISO8601 basic hm, without Z | xx | -0800, +0000 | |
Time Zone: ISO8601 extended hm, without Z | xxx | -08:00 | |
Time Zone: ISO8601 basic hms?, without Z | xxxx | -0800, -075258 | |
Time Zone: ISO8601 extended hms?, without Z | xxxxx | -08:00, -07:52:58 | |
O | Time Zone: short localized GMT | O | GMT-8 |
Time Zone: long localized GMT (=ZZZZ) | OOOO | GMT-08:00 | |
z | Time Zone: specific non-location | z, zz, o zzz | -0800 |
zzzz | GMT-08:00 | ||
zzzzz | -08:00, -07:52:58, Z | ||
' | escape for text | ' | ' |
' ' | two single quotes produce one | ' ' | ' ' |
Explorar modelos
y
vs Y
y
is the calendar year, while Y
is the year based on the week number. For example, if the first days of January 2010 are not week #1, then y = 2010 but Y = 2009 (until the date where the 1st week of 2010 begins).
L
(monopuesto) vs M
In some languages (Russian, Slovak), the month used alone is different from the month in a date. In "January 10, 2010", "January" is not spelled the same as in "rendez-vous in January".
e
vs c
Same remark as for L
and M
: c
is for a day used alone "every tuesday") and e
is for a day in a date ("Tuesday January 15, 1951").
E
vs e
e
is based on system settings: if the week is defined in the system as starting on a Wednesday, then Wednesday will have the numerical value "1" (or zero) whereas "E" always returns the same value (from 1 to 7 or from 0 to 6).
Ceros a la izquierda
In general, when the number of letters in the formatting string is higher than the expected number, leading zeros are added. Ej: "yyyyy" daría "001996".
Partes localizadas
Some parts of the outputs, such as "midnight" or "Tuesday" are localized, according to regional settings.
For example, for the time 13:25:34
, "B" will display in the afternoon on an US system, and après-midi on a French system.
Letras adicionales
Formatting strings can contain characters not to be interpreted as formatting characters: if they are between "a" and "z" or "A" and "Z", they must be enclosed in single quotes.
Por ejemplo:
"15:30:00" with pattern "HH 'hours and' mm 'minutes'" produces "15 hours and 30 minutes".
Espacios iniciales y finales
Starting and ending spaces in patterns are automatically trimmed in outputs. If you want to add spaces before or after the resulting string, you must enclose them in single quotes.
Por ejemplo:
" HH : mm : ss " ---> "09 : 10 : 25" "' 'HH : mm : ss' '" ---> " 09 : 10 : 25 "
Ejemplos
Fecha u hora | Modelo | Result | Comentarios |
---|---|---|---|
15/06/2000 | "QQQQ" | "2do trimestre" | localizado |
17/03/2001 | "D" | "76" | 76º día del año |
17/03/1954 | "w" | "11" | 11ª semana del año |
17/03/1954 | "eeee" | "Miércoles" | localizado |
15:00:00 | "a" | "PM" | |
18:00:00 | "K a" | "6 PM" | |
13:30:15 | "hh:mm aa O" | "01:30 PM GMT+1" |
Ver también
See this blogpost for more information on the custom date and time formats.