Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5262

Display datetime stored in UTC(Server Time Zone) In Local Time Zone(Clients TimeZone).

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Pentaho and Mysql Servers are located in UTC timezone. The data in MySQL is also stored in UTC timezone. Users can be in any time zone.
      We would like to display data according to Client's specific timezone.

      As example, if the report query returns a transaction date of 9/25/2014 6:00 PM UTC, this should be displayed to a user in Eastern time as 9/25/2014 2:00 PM on the reports.

        Attachments

        1. 1-11-2015 6-26-21 PM.png
          1-11-2015 6-26-21 PM.png
          161 kB
        2. 1-11-2015 6-27-31 PM.png
          1-11-2015 6-27-31 PM.png
          169 kB
        3. 1-11-2015 6-55-59 PM.png
          1-11-2015 6-55-59 PM.png
          224 kB
        4. Prd-5266.prpt
          4 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              nprakash Nikhil Prakash
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: