> 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.
While I agree, this also has its own problems, like the frequest off-by-two
problems with MS software.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
