General - Formats

In this section of the settings, the date and time format for DataStudio can be chosen and also the number format.

General - Formats
Figure 1. General - Formats

Date and Time Format Settings

Table 1. Date and Time Format Settings
Setting Description Example

UTC (ISO8601)

DataStudio will use the UTC date and time format to display timestamps in DataStudio. This is the ISO 8601 standard format so cannot be changed by the user.

2016-06-10T16:21:45Z

Local Time Format

Local Time Format Timestamps with the local time offset, using the format given by the operating system’s regional settings. This is defined by the operating system so cannot be changed by the user.

10.06.2016 18:21:45

Custom

When selected, a custom date and time format can be specified in the adjacent fields (date, date and time separator, time). Custom timestamps use the local time offset.

2016_06_10-18_21_45

Show Milliseconds

Select the checkbox to display milliseconds as part of timestamp.

2016-06-10T16:21:45.034Z

Special Datetime Formats

This setting controls how the VT_DATE value is shown where the Date value has special meaning. Choose Simple, Traditional or _Full_from the drop-down menu.

Simple - Every value below the 1970-01-01 12.00 AM (Minimum Posix Epoch) is shown as 'no timestamp'.

Traditional - All values that translate to 1899-01-01 12:00:00 (VT_DATE with a float value of 0.0) are shown with timestamp only.

Full - Date part of the value will be shown as is, according to the local number settings.

Number Format Settings

Table 2. Number Format Settings
Setting Description

Precision

Maximum number of displayed digits for a number.

Decimal Places

Maximum number of displayed decimal digits (to the right of the decimal point) for a number. If a decimal places number is configured individually for an object then it will override this number.

Digit Grouping

Select this checkbox to group digits to the left of a number’s decimal point using the settings defined in the local language settings.