• ? What is a use for this? Just getting the date for use at another time? If you try to convert the value back to type of datetime you lose the time portion.

    Set @b-2 = '08/31/2010 08:08:08 AM'

    set @a = convert(int, @b-2)

    print @a [result = 40419]

    set @b-2 = convert(datetime, @a)

    print @b-2 [result = Aug 31 2010 12:00 AM]