• Hi,

    try this

    select convert(datetime,40010/*your int value*/,112/*your format*/)