Discussion Overview
The discussion revolves around the interpretation of a 10-digit number in an XML file that appears to represent time, specifically questioning the baseline date from which this time is measured. The conversation touches on concepts of time representation in computing, particularly Unix time.
Discussion Character
- Exploratory
- Technical explanation
- Debate/contested
Main Points Raised
- One participant suggests that the 10-digit number likely represents seconds from a baseline date, inquiring about what that date might be.
- Another participant mentions "date serial" and "time serial" as methods of storing dates and times as numbers, providing a link for further reading.
- Several participants propose that the number represents Unix time, with a specific range of dates identified based on the number provided.
- One participant confirms that Unix time counts seconds since January 1, 1970, and notes that leap seconds are not accounted for in this system.
- Another participant expresses concern about the complexity of converting between Unix time and other date formats, mentioning potential issues with varying month lengths.
- A later reply mentions the existence of conversion functions and online tools for translating Unix time, although the specific formula is not provided.
Areas of Agreement / Disagreement
Participants generally agree that the 10-digit number likely represents Unix time, but there is no consensus on the ease of conversion to other date formats, with some expressing challenges in the process.
Contextual Notes
There are unresolved aspects regarding the conversion process between Unix time and other date formats, particularly concerning the handling of varying month lengths and leap seconds.