Page Comparison

...

...

...

...

...

...

...

...

Syntax

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

Description

...

This function allows you to assign a timezone time zone to values in a a date type column  column and then shift the date values 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 

<Time Zone 1> is the time zone you want for the final values, <Time Zone 2> is the current time zone for the values being shifted. Time Zone 1 is usually the time zone of the Datameer X application server or the user's time zone (if different).

Info
title icontitle false INFO
Information on time and date data within Datameer X pertaining to timezones: Datameer X internally stores all dates as universal time (UTC) . Datameer X displays dates within Workbooks workbooks as a local time for your Datameer X instance . Datameer X recognizes the timezone time zone for dates with an included parsed timezone. time zone Datameer X assigns the your local instance timezone time zone to dates parsed without a timezone.

...

time zone

Info
title INFO
Time zones available for the function's arguments can be found at http://joda-time.sourceforge.net/timezones.html

...

Examples

...

Use-case 1

Datameer X application server runs in the CET time zone (Berlin). A user located in Berlin, Germany has pulled in log files from a server located in Los Angeles, USA. The server logs all data using the local time zone but the dates extracted from the log files had have no assigned 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.. Because there is no time zone stamp, the user's machine interprets the log entries as happening in their local Berlin time. The SHIFTTIMEZONE function lets the user correct this by declaring the time zone they want for analysis "Europe/Berlin" (Time Zone 1) and the time zone that the data is currently in "America/Los_Angeles" (Time Zone 2). 

...

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.

Use-case 2

A server registering events occurring in Los Angeles, USA is set to use UTC time zone and has not been configured to record any time zone in log entries.  A user has pulled in log files from this server. The dates extracted from the log files have no time zone stamp assigned and represent UTC time. The SHIFTTIMEZONE function lets the user correct this by declaring the time zone they want for analysis "America/Los_Angeles " (Time Zone 1) and the time zone that the data is currently in "UTC" (Time Zone 2).

Datameer always uses the following format:

Three character month abbreviation (space) two digit day (comma)(space) four digit year (space) two digit hour (colon) two digit minute (colon) two digit second (space) two character meridiem notation.

...

...

...