In der HubEngine kannst du beim Felder-Mapping für Datum- und Zeit-Angaben den speziellen Feldtyp Date oder Datetime nutzen. So kannst du die Formate sehr einfach an das Zielsystem transformieren.
Das Datum „2022-01-14“ wird beispielsweise mit dem Format „Y-m-d“ dargestellt.
Ein Transformations-Beispiel
- System A gibt über die API folgenden Unix Timestamp aus: 1642114800
- System B erwartet folgendes Format: 2022-01-14
- Folgendes Format wird für das Mapping genutzt: Y-m-d
Weitere Beispiele
Ausgehend vom Unix Timestamp 1642158745 (Freitag, 14. Januar 2022, 11:12:25 in der Zeitzone UTC / GMT+0):
- „Y.m.d H:i:s“ ergibt 2022.01.14 11:12:25
- „d.m.Y H:i:s e“ ergibt 14.01.2022 12:12:25 Europe/Berlin (Zeitzone variiert vom Serverstandort)
- „d.F Y“ ergibt 14.Januar 2022
- „D, d.F Y“ ergibt Fri, 14.Januar 2022
- „Y-m-d H:i:s P“ ergibt 2022-01-14 12:12:25 +01:00 (Zeitzone variiert vom Serverstandort)
Alle verfügbaren Optionen findest du in der folgenden Tabelle.
Wird kein gültiger Zeitstempel oder kein gültiges Datum übergeben, führt die Transformation zu einer leeren Zeichenkette. Durch Hinzufügen von „||null“ nach dem Format (z. B. Y-m-d||null) ergibt die Transformation keine leere Zeichenfolge, sondern NULL.
| Character | Description | Example returned values |
|---|---|---|
| Day | — | — |
d |
Day of the month, 2 digits with leading zeros | 01 to 31 |
D |
A textual representation of a day, three letters | Mon through Sun |
j |
Day of the month without leading zeros | 1 to 31 |
l |
A full textual representation of the day of the week | Sunday through Saturday |
N |
ISO 8601 numeric representation of the day of the week | 1 (for Monday) through 7 (for Sunday) |
S |
English ordinal suffix for the day of the month, 2 characters | st, nd, rd orth. Works well with j |
w |
Numeric representation of the day of the week | 0 (for Sunday) through 6 (for Saturday) |
z |
The day of the year (starting from 0) | 0 through 365 |
| Week | — | — |
W |
ISO 8601 week number of year, weeks starting on Monday | Example: 42 (the 42nd week in the year) |
| Month | — | — |
F |
A full textual representation of a month, such as January or March | January through December |
m |
Numeric representation of a month, with leading zeros | 01 through 12 |
M |
A short textual representation of a month, three letters | Jan through Dec |
n |
Numeric representation of a month, without leading zeros | 1 through 12 |
t |
Number of days in the given month | 28 through 31 |
| Year | — | — |
L |
Whether it’s a leap year | 1 if it is a leap year, 0 otherwise. |
o |
ISO 8601 week-numbering year. This has the same value asY, except that if the ISO week number( W) belongs to the previous or next year, that yearis used instead. |
Examples: 1999 or 2003 |
Y |
A full numeric representation of a year, 4 digits | Examples: 1999 or 2003 |
y |
A two digit representation of a year | Examples: 99 or 03 |
| Time | — | — |
a |
Lowercase Ante meridiem and Post meridiem | am or pm |
A |
Uppercase Ante meridiem and Post meridiem | AM or PM |
B |
Swatch Internet time | 000 through 999 |
g |
12-hour format of an hour without leading zeros | 1 through 12 |
G |
24-hour format of an hour without leading zeros | 0 through 23 |
h |
12-hour format of an hour with leading zeros | 01 through 12 |
H |
24-hour format of an hour with leading zeros | 00 through 23 |
i |
Minutes with leading zeros | 00 to 59 |
s |
Seconds with leading zeros | 00 through 59 |
u |
Microseconds | Example: 654321 |
v |
Milliseconds. Same note applies as foru. |
Example: 654 |
| Timezone | — | — |
e |
Timezone identifier | Examples: UTC, GMT, Atlantic/Azores |
I (capital i) |
Whether or not the date is in daylight saving time | 1 if Daylight Saving Time, 0 otherwise. |
O |
Difference to Greenwich time (GMT) without colon between hours and minutes | Example: +0200 |
P |
Difference to Greenwich time (GMT) with colon between hours and minutes | Example: +02:00 |
p |
The same as P, but returns Z instead of +00:00 |
Example: +02:00 |
T |
Timezone abbreviation, if known; otherwise the GMT offset. | Examples: EST, MDT, +05 |
Z |
Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive. |
-43200 through 50400 |
| Full Date/Time | — | — |
c |
ISO 8601 date | 2004-02-12T15:19:21+00:00 |
r |
» RFC 2822 formatted date | Example: Thu, 21 Dec 2000 16:01:07 +0200 |
U |
Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) | — |