In Zuora, dates change at midnight (12:00 AM), which is considered to be the beginning of the day. For example, a period of time that extends from January 1 through February 1 begins at midnight January 1 (immediately after 11:59 PM, December 31), and ends at midnight on February 1 (immediately after 11:59 PM, January 31) is one day. Zuora creates charges based on calendar days, and the time of day does not affect billing. Whether a charge begins at 4 PM or 4 AM on a given day, Zuora calculates the charge in the same way.
Zuora supports the following dateTime formatting conventions:
|With Offset|| || |
|Without Offset|| || |
Zuora observes Daylight Savings Time and converts input dateTime values to GMT-7 or GMT-8 depending on the input value. For example:
2015-11-01T02:00:00will have a time zone offset of GMT-7
2016-03-13T02:00:00will have a time zone offset of GMT-8
Zuora appends any dateTime value without a time zone offset component with GMT-7 or GMT-8. For example:
In WSDL 68 and earlier, 56 Zuora SOAP API date fields are treated as dateTime fields. As of WSDL 69, Zuora will treat these fields as date only fields. These fields are no longer compatible with dateTime values. Date and dateTime values in WSDL 69 are now the same as date and dateTime values in the Zuora application.
Before downloading and using WSDL 69, check to see if your SOAP integration passes or receives dateTime values to or from any of these fields.
See Date Field Changes in the SOAP API for more information.
Dates and dateTimes are stored as dateTime values. To reduce potential mistranslations of time, Zuora recommends that you use one of the following methods when working with dateTimes:
2011-01-01T03:18:09+02:00, do not translate the dateTime value to GMT-7/-8. In this case, you should switch the time zone offset to GMT-7/-8 like so:
From WSDL 69 and later, Zuora treats date fields as date fields and dateTime fields as dateTime fields. For WSDL 69 and later, use the following methods:
In WSDL 68 and earlier, the output format of dates and times in data source exports depended on the value stored in the database. If a time is stored with the date, it is displayed as a date and time. If no time is stored with the date or the time component is
00:00:00, the result will be displayed as a date only, with no time.
From WSDL 69 and later, the output from dateTime fields will be a dateTime and the output from date fields will be a date.
See Export ZOQL Dates and dateTimes for more information.
If you are using WSDL 69 or later, the output from dateTime fields will be a dateTime and the output from date fields will be a date.
In WSDL 68 and earlier, dateTimes read via the query() call from Zuora are returned in GMT-7/-8. To overcome the SOAP native field limitation, a time zone offset is not returned for select fields.
This date will be returned as:
The following fields do not return a time zone offset in WSDL 68 and earlier: