Overview
All dates and times are stored in the Cordial database in UTC (Coordinated Universal Time). When dates and times are displayed in the UI, they are converted to the time zone that was set up for the account.
Depending on where dates and times are viewed (in the UI or via API), they will be displayed as follows:
| Display | Time Zone | Format | Example |
|---|---|---|---|
| Viewed in UI (custom events, message events, audience rules, etc.) | Account Time Zone | Textual month, day, year and time | Nov 16, 2024 4:12 pm |
| Viewed in API | UTC | ISO Standard | 2024-11-17T00:12:49+0000 |
1.) When exporting data from the UI, times will be displayed in the UTC time zone. 2.) When using the Smarty Now variable {$smarty.now} in a message, time will be displayed in UTC time in UNIX format.
Date formatting
When passing data, Cordial can only accept date values in the following formats.
November 5, 2024 =
11/05/20242024-11-052024-11-05T00:00:00Z
What is my account's time zone?
The account's time zone is set up by a Client Success Manager when the account is configured. To see which time zone your account is set for, contact your Client Success Manager or use the account variable: {$account.timezone} to render the time zone in a message.
Time zone offset
You can use the time zone offset to account for queries from a particular time zone. You simply need to include the time difference between your endpoint's time zone and UTC.
Use case
A query might have the timestamp of
2024-07-11T00:00:00-0000in UTC. The timestamp for the same query in Eastern Standard Time would be2024-07-11T00:00:00-0500because EST is five hours behind UTC.
Comments
0 comments
Please sign in to leave a comment.