Michael Van Canneyt wrote:
On Tue, 4 Apr 2006, Arí Ricardo Ody wrote:
Alright Michael. The fact is that there is tables that have TIMESTAMP
columns with more than 3 digits of fraction... I'm trying to say that
I think that you can't ignore it with simplicity. Or can you?
No, you have a point there.
But it will be rarely used, since no other engine I know of has this type.
(maybe oracle, but I don't know about that)
Oracle has it, but you cannot use it with delphi.
As a test I create a table with just one timestamp field.
In Delphi I couldn't access the table neither native nor using a MS
oracle odbc driver nor a Oracle80 odbc driver.
Browsing the table with OraTools completely locked up oratools.
I wonder if Delphi would support this for DB2.
I trying to explain since this discussion starts that, at least,
Lazarus/FPC can be able to handle 6 digits of fraction. Otherwise in
can't process tables generated from some other languages(cobol, for
example). Or you can create a Lazarus/FPC TIMESTAMP version.... :-[
We'd need a TPrecisionDateTime or TNanoDateTime;
It would be an Int64 or so, with the number of
nanoseconds since 1/1/1900; Int64 should be enough to store that.
But definitely not text.
That is maybe an idea.
Marc
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
