Tell me more ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.
up vote -2 down vote favorite

I'm curious about how date and time related datatypes are stored in different database architectures?? How data structures for datatime dts are different in different DBMSs?

share|improve this question
3  
What research have you done yourself? There are several formats, depending on what one is optimizing for. Given that mysql datetime gives some hints (the DATETIME is 8 butes while TIMESTAMP is 4 - the timestamp is the unix 32 bit time - TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC). Closed source databases are less informative. – MichaelT Apr 15 at 15:46
Myself, digging into it a little, mysql manual section 11.9. Date and Time Data Type Representation goes into how they are represented in mysql. – MichaelT Apr 15 at 17:47
I did a little research but what I couldn't find what I'm looking for. This information you have cited here, are just referring to data size, but I'm digging into its data structures and algorithms to process that structure.. tnx for ur comment. – omid.n Apr 16 at 4:17
What's more I can't understand why staff doesn't like my questions very much and close my question?!! :) – omid.n Apr 16 at 4:19
Identifying the information you found is useful for us, so that we don't explain it again. Questions that are asking for resources are a poor fit for the Q&A format - someone could answer with the mysql structure and another for sybase and both answers would be right (this is a problem). The key to asking a question in a Q&A site is to identify the problem you are having and looking for a solution rather than just casting a wide net. And this is a very wide net - I had a weeks worth of college lectures on date data structures in a database. 3 hours of college lectures doesn't fit in a textbox. – MichaelT Apr 16 at 13:29
show 1 more comment

closed as not a real question by Robert Harvey, gnat, Martijn Pieters, BЈовић, Evan Plaice Apr 15 at 17:48

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.