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 für Date oder Datetime kein gültiger Zeitstempel oder kein gültiges Datum aus dem Quellsystem A an die HubEngine übergeben, führt die Transformation zu einer leeren Zeichenkette und setzt für das Mapping automatisch den Wert Null, der dann in das Zielsystem B übertragen wird.
Möchtest du statt dem Wert Null das aktuelle Datum im Zielsystem haben, dann kannst du die Pipe-Option ||now in den Optionen angeben.
| 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) | — |