On Tue, 4 Apr 2006, Arí Ricardo Ody wrote:
At 17:27 3/4/2006, you wrote:
Sure, but what I understood from Bram, some other Timestamp/Datetime
fields were working, only this particular sort of Timestamp isn't.
If you think carefully you'll conclude that there is only one type of
TIMESTAMP: day, month, year, hours, minutes, seconds and 1/1e6 of seconds.
All other types are derived from this format, the complete TIMESTAMP format.
This is theory. In practice, each DB engine stores this information in
a different format (or several formats, as in the case of DB2), and
even worse, returns it in yet another format.
To offer the pascal programmer a UNIFORM interface, which is the same
across all DB engines, all dates are represented as a TDateTime value.
Regardless of the internal format of TDateTime, using a text value
is definitely out, because then you will be stuck with different
date notations. Not to mention that it takes more memory to store
it as text, and this is also bad.
Michael.
