Converting UNIX timestamp (BIGINT) to DATETIME value using DATEADD function

Contrary to popular belief, offices can be fun – especially if you are faced with new challenges each day. Hence, this week, we will be taking a small break from discussing the “Underappreciated features of SQL Server”, and instead discuss something that happened at the office a few days ago. One of the project engineers asked me a seemingly very simple question. “Can I represent a UNIX time