Update 2014-04-14: Contact List Upload Time Zone Details Updated

Update 2017-12-06: API Endpoint Details Updated

 

As most of you know, the Eloqua servers are set to the Eastern (North America) time zone. That means, all dates/times are stored in the database adjusted to GMT-5 (and most likely GMT-4 when Daylight Saving Time is active). I still don't have an exact, technical description of what happens when the time zone switches from GMT-5 to GMT-4, and back; the system just compensates somehow.

 

Anyway, the times in different parts of the application are adjusted to, or displayed in, different time zones. The problem is, there's little-to-no indication of what time zone is being used for each of the date/time displays. I'm trying to compile a list of the different parts of the application, and what time zone is being used. HINT: Most of it is Eastern Time (GMT-5 at least; not sure entirely about DST/GMT-4).

 

The following is my understanding of the current state of the system, and pulled from various Topliners posts (e.g. What should Eloqua focus on for the next release?, Does Time Zone setting work for a separate user or a whole data center?, Adjusting form submisson time to match timezones?). The first link above has a good overview of this information; might also be worth the time to vote. This is not complete nor authoritative. If anything is incorrect or needs clarification, let me know. Tested at least most of these in E10; I believe the majority should apply to E9.

 

Component / Module / ThingTime Zone UsedNotes
Contact List UploadGMT-5

DST Not Observed

(example below)

Contact Filters / Segment Filters / Shared Filters DateTime FieldsEastern (North America) TimePossibly between GMT-5 and GMT-4 depending on Daylight Saving Time*
Campaign Canvas Compare Contact Fields on a DateTime Field / Program Builder Date ComparisonEastern (North America) TimePossibly between GMT-5 and GMT-4 depending on Daylight Saving Time*
Contact Details / Campaign Contact Entry and Next Evaluation Time / Contact Filter Results

Eloqua User Time Zone

Configurable under Setup > Profile
Insight Subscription Report Scheduling / Insight DateTime Fields / Insight DateTime Range PromptsEastern (North America) TimePossibly between GMT-5 and GMT-4 depending on Daylight Saving Time*

Cloud Connectors (Last Run Time, Date Calculator, etc.)

This needs to be retested for the new AppCloud Framework apps.

Greenwich Mean TimeSet to GMT/UTC. DST Ignored.
Form Submission Data (View in Eloqua)Eloqua User Time ZoneConfigurable under Setup > Profile
Form Submission Data (Export) / Form Submission NotificationsEastern (North America) TimePossibly GMT-5 / GMT-4 depending on DST*
Program Builder Test Mode (System Date and Time Override Input)Eastern (North America) TimePossibly GMT-5 / GMT-4 depending on DST*
Program Builder Test Mode (Display Entered Date and Time Override)Eloqua User Time ZoneConfigurable under Setup > Profile
Program Builder Entry / Exit / Evaluation Histories, Last UpdateEloqua User Time ZoneConfigurable under Setup > Profile
CRM Integration External Calls - Actual Data Written to the CRM - Date/Time Stamps (Date Modified, Date Created, etc.), Activity Dates/TimesEastern (North America) TimePossibly GMT-5 / GMT-4 depending on DST*
API Integration (Input and Output) / Asset Last Modified Date through APIEastern (North America) TimePossibly GMT-5 / GMT-4 depending on DST*
Asset Last Modified Date (View in Eloqua)Eloqua User Time ZoneConfigurable under Setup > Profile
CRM Integration Auto Synch Scheduling - Default TimeEastern (North America) TimeAlthough the interface says "10pm EST", that is not accurate; it follows DST.

 

*Switching between DST needs to be verified.

 

 

API Endpoint Details

 

 

bulk/2.0/contacts/exports (Specifically, the resulting contact export sync data)

By default, all times are in Eastern Time and the same as shown in the UI (if your profile is set to Eastern Time). This applies to system-level fields (e.g. {{Contact.CreatedAt}}) as well as customer-created fields (e.g. {{Contact.Field(C_Inquiry_Capture_Date1)}}).

Now, you can add a parameter to your export definition -- "areSystemTimestampsInUTC":"true" -- and this will change only the system-level fields to UTC. Customer-created fields will remain as Eastern Time.

 

NOTE: "Eastern Time" in this context varies between UTC-4 and UTC-5 depending on the date value in that particular fields.

For example, a Date Created (system field) value of "2017-04-30 04:58:49.423" without the areSystemTimestampsInUTC parameter will return "2017-04-30T08:58:49.423Z" with "areSystemTimestampsInUTC":"true" (meaning UTC-4, as DST was active in the Eastern Time Zone on 2017-Apr-30). Similarly, a Date Created value of "2017-12-06 22:01:34.680" without areSystemTimestampsInUTC will return "2017-12-07T03:01:34.680Z" (UTC-5 as DST was not active on 2017-Dec-07) with that parameter set to "true".

 

rest/2.0/data/contact/<id>

Here, all dates (system fields and customer-created fields) are exported in UTC, irrespective of user's profile settings (unlike the Bulk export, where even with areSystemTimestampsInUTC=true, only the system fields are exported in UTC). The timestamps are in epoch time/Unix time (number of seconds from 1970-01-01 00:00:00 UTC). For example, a date of "2017-12-06 22:01:34" as shown in the UI (Profile:Eastern Time) will be exported as 1493542729 (2017-12-07 03:01:34 -- UTC-5), while a date of "2017-04-30 04:58:49" will be 1493542729 (2017-04-30 08:58:49 -- UTC-4).

 

bulk/2.0 fields, definition, and sync createdAt and updatedAt timestamps are UTC.

 

Just to stress this again: If you created a new Contact date field, the Bulk API will always export that value in Eastern Time (UTC-4/UTC-5 depending on that value's date), irrespective of the "areSystemTimestampsInUTC" parameter. However, the REST API will always export that value in UTC with no option to export the as-is database value.

 

 

 

Update: Times in list uploads are processed according to GMT-5 (NO DST).

List Upload Example: Your Eloqua user profile is set to GMT+2. You upload a list with a date/time of "10/13/2014", which is interpreted as "2014-Oct-13 00:00:00". Currently, Eastern (North America) is observing DST, so it's really GMT-4, here. When you view the contact, the time will show as 7:00AM (not 6:00AM).

 

Update: It seems like Eloqua User Profile Time Zones do not observe DST whatsoever; whatever GMT±XX is shown in the selection, that's the time zone offset used (at least for Contact date/time field displays). In the above example, if the Eloqua user profile is set to "(GMT-05:00) Eastern Time (US & Canada)", the time will show as 12:00AM (not 1:00AM).

 

Update: The default scheduling option for auto synchs is "Auto-Synch Runs on Selected Days at 10pm EST?", but that is not accurate. EST (Eastern Standard Time) is UTC-5, but the scheduling option actually switches between EST and EDT. So, if you were in Thailand (ICT, UTC+7, no DST), between Nov 2 and Mar 8 the synch will run at 10:00AM local time, but between Mar 9 and Nov 1, it will run at 9:00AM local time.

 

 

For details on the date/time text format for list uploads, see List Upload Date/Time Formats