How can I read SQL datetime formatting?

Obviously MS SQL formats date as something like 1259300084 is hard to match to real date time, so I would like to be able to find algorithm to read it...