Home Forums SQL Server 2005 Development convert date object into integer RE: convert date object into integer

  • September 27, 2008 at 6:16 am

    #878069

    or is it what you are looking for?

    select cast(getdate() as int)

    /*

    39717

    */

    select cast(39717 as datetime)

    /*

    2008-09-28 00:00:00.000

    */

    .