Timezone support

Kx Stream provides a set of analytics to convert between timezones and allow for daylight-savings time.

The APIs can be added to any process by adding the DxTZ analytic group to the instance.

The timezone data is stored as a table of offsets from GMT built from a CSV file. This file is built from the IANA timezone database and updated with every release.

dxTZFromGMT

Syntax: dxTZFromGMT[tz;ts]

Converts timestamp ts to GMT from timezone tz.

q)dxTZFromGMT[`$"America/New_York"; 1976.02.01D00:00:00.0]
,1976.01.31D19:00:00.000000000

dxTZToGMT

Syntax: dxTZToGMT[tz;ts]

Converts timestamp ts from GMT to timezone tz.

q)dxTZToGMT[`$"America/New_York"; 1976.05.01D00:00:00.0]
,1976.05.01D04:00:00.000000000

dxTZSwitch

Syntax: dxTZSwitch[tz1;tz0;ts]

Converts timestamp ts from timezone tz0 to timezone tz1

q)dxTZSwitch[`$"Asia/Kolkata"; `$"America/New_York"; 1976.05.01D00:00:00.0]
,1976.05.01D09:30:00.000000000