SQL queries for time return offset values only on Object Browser

Question

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!

Niels de Groot · Accepted Answer

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.

SQL queries for time return offset values only on Object Browser

Top Replies