I have a column in a table which shows time in UTC. How can i import this time as UTC in DB Connect 2

[graa1005]

My SQL server is in CET All datetime columns are imported in CET. Now I have one table in which the datetime is stored in UTC. How can I import this UTC time column in DB Connect 2 so DB connect knows that this column is in UTC instead of CET.

[jkat54]

You can just do it in your SQL query

https://msdn.microsoft.com/en-us/library/ms186819.aspx

SELECT DATEADD(hour, -1, DATEADD(second, yourTimeStampColumn, '1970-01-01'))