1

Date /time zone adjustment

date/time values are stored in our data base as UTC.  I would like to have these represented in Central time in Incorta.  Will setting the time zone on the tenant in the admin portal accomplish this?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Amy,

    Yes, setting the GMT offset in the tenant will apply to all of your timestamp fields. The setting change does require restarting Analytics service. Alternatively, you can adjust time zones on a field-by-field basis with the addMinutes() function in formula column or insight. A more full-featured timezone function is on the product roadmap. 

    Thanks,

    Dustin

    Like
  • Dustin Basil  is it valid on most recent incorta versions? 

    Like
    • Siva Kowsika No, this is not valid on recent versions. Incorta will reflect the timezone of the server it is installed on. To change the displayed timezone, you can either change the server OS timezone or pass desired timezone to the JVM running Incorta and perform a staging load of all Schemas. I recommend customers not comfortable with this process reach out to Incorta support for more detail or assistance. Steps below: 

      The steps to change the JVM timezone is as below: 

      1. backup the file 'startService.sh' located under '<incorta_installation_path>/IncortaNode'
      2. edit the file changing the line below

      from: 

      export JAVA_OPTS="-Xms"$memorySize" -Xmx"$memorySize" -Dfile.encoding=UTF-8"
      
      

      To: 

      export JAVA_OPTS="-Xms"$memorySize" -Xmx"$memorySize" -Dfile.encoding=UTF-8" -Duser.timezone=America/Los_Angeles
      
      

      3. the above change to be done on both loader and analytics nodes. 

      4. restart the services. 

      5. do a full load from staging

      Like 1
Like1 Follow
  • 1 Likes
  • 2 wk agoLast active
  • 3Replies
  • 69Views
  • 3 Following