Skip to main content
B
BrianToussaint19-Tanzanite
19-Tanzanite
February 15, 2024
Question

Timestamp Difference Between Database Table and Windchill GUI

  • February 15, 2024
  • 1 reply
  • 2136 views

I am using Windchill PDMLink Release 12.1.2.6.

Why is the timestamp off from what is in the SQL database to what is presented in Windchill? I do not know what the database is using for the time zone since it is 3 hours off from EST right now. So that isn't even UTC time. I have a task that in the database is showing created December 9, 2023, 12:16 AM and in the interface it shows 2023-12-08 19:16 EST, which is only 3 hours and not the standard 5 for UTC.

I am trying to setup metrics using Metabase and this is throwing averages off on some items.

1 reply

B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
February 15, 2024

Look in the Windchill Preferences for Attribute Handling and the setting for Local Time Zone. We found a bug in the system that it must be set at the Site level preferences in order to display times in the information pages in the correct local time. The database, at least with Oracle, uses UTC to store the time.

    HelesicPetr
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    February 16, 2024

    Hi @BenLoosli 

    Also the time store in UTC is ok, but if the database server has wrong local zone settings it can case also the time differences.

    PetrH

    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    February 16, 2024

    I saw, just yesterday, this presentation on version 13.0.1 where they explained that, among the new features, is that in the query builder reports make sure that problems on dates are fixed when the system is set up with a local language.

     

    What's New for Windchill 13.0.1
    https://community.ptc.com/t5/Windchill-Tips/What-s-New-for-Windchill-13-0-1/ta-p/918755

     

    Marco
    Terms & ConditionsAccessibility statement