Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

ECL function request - Given an UTC time, convert it to the locale time provided the locale

Description

Similar to:

DateFormat pstFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS");
pstFormat.setTimeZone(TimeZone.getTimeZone("PST"));

System.out.println(pstFormat.format(date));

Example usage: Client browser is required to show column information in local time. Client calls a Roxie query, the query accepts a locale parameter along with other parameters, process the request and returns the localized results.

Conclusion

None

Activity

Show:

Dan Camper February 12, 2018 at 4:15 PM

Opted to go for a more basic solution than what was intended with the TimeZoneDB data.

Dan Camper March 22, 2017 at 12:33 PM

Currently looking at leveraging freely-available information at timezonedb (https://timezonedb.com). That data supports worldwide time zone lookups, contains as-of timestamps (so you can lookup GMT offsets at a point in time, not just "now"), and is DST aware.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Components

Assignee

Reporter

Priority

Fix versions

Pull Request URL

https://github.com/hpcc-systems/HPCC-Platform/pull/10871

Affects versions

Created January 12, 2017 at 9:40 PM
Updated April 25, 2018 at 11:08 AM
Resolved April 25, 2018 at 11:08 AM