Dates and Times
The Qualtrics APIs use date and time values which follow the ISO 8601 standard. Each value represents a specific point in time. Also, some older endpoints feature Unix time instead of ISO 8601.
ISO 8601 Date and Time Format
In general, although the ISO 8601 standard specifies many different date and time formats, the typical date and time value specifies the date as YYYY-MM-DD (where YYYY indicates a four-digit year, MM is a two-digit month, and DD is the two-digit day of the month) followed by the character "T" and then the time as hh:mm:ss (where hh is a two-digit hour in military time format [00-23, no AM or PM], mm is the two-digit minutes past the hour, and ss is the two-digit seconds) followed by the character Z which indicates UTC. Instead of Z, a time zone offset from UTC can be indicated as plus (+) or minus (-) followed by HH:mm.
The following shows examples of ISO 8601 dates and times:
- 2019-03-21T10:16:12Z000 represents March 21, 2019 at 10:16:12 AM and 0 milliseconds UTC.
- 2016-04-01T07:31:43Z represents April 1, 2016 at 7:31:43 AM UTC.
- 2017-02-07T14:02:11-08:00 represents February 7, 2017 at 2:02:11 PM in the PST time zone (UTC minus 8 hours).
Some APIs will not accept milliseconds
There are some APIs that will return an error if you pass in a date time with milliseconds, and you may need to strip the milliseconds from the date time prior to using them.
All dates and time values returned by the APIs are expressed in UTC unless the API allows you to return values in local time. For example, Create Response Export has the localTime parameter that, if set to true, causes the times in the responses to be expressed in the time zone set in the admin user interface. See Managing Your Account for more information.
Unix Time
The Unix time stamp tracks time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. The Unix time stamp is the number of seconds between a particular date and the Unix Epoch.
The following shows examples of Unix Time dates and times:
- 1553163372 represents March 21, 2019 at 10:16:12 AM UTC.
- 1459495903 represents April 1, 2016 at 7:31:43 AM UTC.
- 1486504931 represents February 7, 2017 at 10:02:11 PM UTC.
Time Zones
Some API calls accept a "timeZone" argument. Allowed Time Zone IDs are defined here:
| Time Zone Id |
|---|
| Pacific/Midway |
| Pacific/Honolulu |
| America/Anchorage |
| America/Los_Angeles |
| America/Phoenix |
| America/Denver |
| Canada/East-Saskatchewan |
| America/Chicago |
| America/Rio_Branco |
| America/New_York |
| Canada/Atlantic |
| America/La_Paz |
| Canada/Newfoundland |
| America/Montevideo |
| America/Argentina/Buenos_Aires |
| America/Noronha |
| Atlantic/Azores |
| Atlantic/Cape_Verde |
| Atlantic/Reykjavik |
| Europe/London |
| Europe/Berlin |
| Africa/Bangui |
| Europe/Athens |
| Africa/Harare |
| Europe/Moscow |
| Africa/Nairobi |
| Asia/Tehran |
| Asia/Muscat |
| Asia/Baku |
| Asia/Kabul |
| Asia/Yekaterinburg |
| Asia/Karachi |
| Asia/Calcutta |
| Asia/Katmandu |
| Asia/Dhaka |
| Asia/Novosibirsk |
| Asia/Rangoon |
| Asia/Krasnoyk |
| Asia/Yakutsk |
| Asia/Seoul |
| Australia/Daarsk |
| Asia/Bangkorwin |
| Australia/Adelaide |
| Australia/Brisbane |
| Australia/Canberra |
| Asia/Magadan |
| Pacific/Auckland |
| Pacific/Fiji |
| Pacific/Tongatapu |