aspen

AspenTech IP.21 Data Timezone


I am doing a simple query to retrieve data via ODBC and OdbcDataReader. However, I am not able to determine what the time zone of the data returned is. I have checked every doc and nothing tells me what it is (UTC or local). I tried to look for a setting in SQL Plus and was unable to find something there either.

Does anyone know or know what docs would say? Thanks!


Solution

  • In AspenTech IP21 SqlPlus, every timestamps you are relevant to server timezone.
    If you are only interested in UTC offset (beware, timezone is not just that), you can ask the server its current time, and do the calculation:

    --something like that :
    WRITE GETDBTIME;
    

    Also, if you have right on the server, you could call a system command (check the doc for the correct syntax) to have the name of the Timezone:

    SYSTEM 'tzutil /g';
    

    Screenshot with result