SHIFTTIMEZONE

Syntax

SHIFTTIMEZONE(<date>;<Time Zone>;<Time Zone>)

Description

Adjust an incorrectly labeled date to the correct timezone.

This function allows you to assign a timezone to values in a date type column and then shift the date to a different time zone. The result of the function has a date column with the dates displayed in the Datameer instance's local timezone.

Timezones available for the To and From input fields in the function can be found on: http://joda-time.sourceforge.net/timezones.html

Examples

In this use case example, a user located in Berlin, Germany has pulled in log files from a server located in Los Angeles, USA. The dates extracted from the log files had no time zone stamp assigned.

These dates are currently being displayed in local time for the user's Datameer instance which is in Berlin. (GMT+2). The problem is that these time stamps for the log events that happened during Pacific time (GMT-7).

The SHIFTTIMEZONE function lets the user assign a timezone to a date column and then reassign it to a new timezone which updates the displayed results.

Below, the timezone for Berlin, Germany is being assigned, in the "From Timezone" field, as the initial incorrect timezone. The second field, "To Timezone", is assigning the date to be correctly identified in the Los Angeles, USA timezone.

The timezones are being shifted from GMT+2 to GMT-7.

The result of the function will have a date column with the dates displayed in the corrected timezone.

Here, the log time is now being shown correctly in Berlin, Germany (local server time) for the log events that took place in the Los Angles, USA timezone.