Dave Ballentine showed you step by step how the conversion is going to work; but if you use the final answer, you don't get the timne portion, just the correct date;
you lose the modulus of the integer division;
you should shortcut and just use the DATEADD function to add the total seconds:
select dateadd(dd,14249,'19700101') --add the offset for the stored date
select (1231151827 % 60) --sec to min gain 7 seconds from
select 20519197 % 60 --min to hour gain 37 minutes
select 341986 % 24 --hour to days gain 10 hours
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!