• State Verified Answer
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 131 views
  • Users 0 members are here
Options
Related

SQL queries for time return offset values only on Object Browser

ertyui
15 days ago

Hello,

I ran into an interesting problem. Running SQL queries like GETUTCDATE, GETDATE, SYSDATETIME, and SYSUTCDATETIME all return wrong values with the local offset added on them when queried on Object Browser, but correct time on the SQL Server itself.

I've assumed generally that the SQL Queries would display the same values on OB as on SQL Server, but apparently my assumption is wrong.

Could anyone help me understand what is happening here?

Thanks!

  • +1 13 days ago

    Good catch, but I think this is intentional.
    In all the Front-End tools time is shown in current Time zone.
    Whereas the object layer (VI.DB) and the database itself work with the UTC time.
    In the Object Browser the incorporated SQL editor is the exception, here you can bypass the object layer.
    But I think they took the liberty to convert all the date values for consistency in the overall user experience.

  • 0 13 days ago in reply to Niels de Groot

    Alright. This can potentially cause some confusion and alarm, but knowing that it's just a quirk of how it's displayed and not a symptom of some more serious problem should be enough. Thanks for the answer!