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 the API), they will be displayed as follows:

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.

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 2022-07-11T00:00:00-0000 in UTC. The timestamp for the same query in Eastern Standard Time would be 2022-07-11T00:00:00-0500 because EST is five hours behind UTC.