Home Forums SQL Server 2008 SQL Server 2008 - General How to convert the integer value to datetime RE: How to convert the integer value to datetime

  • October 22, 2012 at 6:30 am

    #1551338

    sanjay.dakolia (10/22/2012)

    this value was suppose to be datetime but by mistake the column datatype was given integer so now i want to convert it back to datetime

    What date does 1157068800 represent?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]