Details

    • Type: Bug
    • Status: Deployed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 4.5.1.000
    • Labels:
    • Environment:

      OS: Windows Server 2008 R2 SP1 - timezone PST
      Database: Teradata 15.0 - timezone PST
      Datasource: Other JDBC Driver
      Lucee Locale: English (United States)
      Lucee Server and Web instances - timezone "PST8PDT - Pacific Standard Time"

      Description

      My timezone setting on the OS and database is PST, and Lucee is PST8PDT. However, Lucee seems to be converting my database timestamps to UTC. The database contains data with the correct timestamp; for example, 6/11/2015 14:54:50. However, when doing a cfquery(SELECT) the timestamp returned isn't correct; for example,

      {ts '2015-06-11 22:54:50'}

      . I've also attempted changing the datasource timezone from 'Same as Lucee instance' to 'PST8PDT'.

      This is a major problem if timestamps from the database are auto converted. Is anyone else facing this issue? Is there a workaround/setting that I'm missing?

        Attachments

          Activity

            People

            • Assignee:
              michaeloffner Michael Offner
              Reporter:
              pjayaprakash Priya Jayaprakash
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: