Convert UNIX Timestamps to DATE/TIMEs in SQL Server – Part#1


tl;dr

A complete and documented function is available at the end of the article.

You don’t know what you’re missing though.

« Thank You »

Thank you, Mr. Steve Jones, for all the work you do for this wonderful community of SQL Professionals and for keeping this site viable and strong.  I also thank Phil Parkin for the incredible proof reading job he did.  It’s amazing how much one can miss when proof-reading their own writings and he caught it all.  Thank you, Phil!

Prologue Figure 1 – A physical timestamp (Click image for more info)

A decade ago, it