UTC int Convert to standard DateTime how?
Posted on 2005-03-03
I have a UTC int, how do I convert this to a standard datetime. Example, the UTC int 1104178047 is the date of 2005-03-02. I need to do the conversion in tsql. Both date and time are needed. There are several proposed solutions I've found on the web, but they are incorrect. Most involve using the DATEADD function. But this does not work. See expert exchange Solution Title: Convert UTC Date to MM/DD/YYYY HH MM SS for one such example. The correct answer can be verified by using the C++ function GMTime. This problem requires an understanding of UTC, a typical date solution will not work.