CanI Use TimeStamp

[watanove]

At First
Sorry,I can write only
very strange English
or something like English.

I use DOA 3.4.6
with Delphi6(ent) and Oracle 9i.

I want read/write TimeStamp Column;

But,I can't do it.

FieldByName('aTimeStampField').AsDateTime
Occur a Convert Error;

When I watch it in SQL Editor
it will be shown like
2002-02-08 00

when I watch it in SQL*Plus
it will be shown like
2002-02-08 00:00:00.000000

Is there any property to set
or
any restrinction?

 

[Marco Kalter]

In the current 3.4.6 release you need to use the to_char() function in your query to convert the timestamp to a varchar2, and treat it as a string field in your application. You will have to explicitly perform a conversion to TDateTime if you need the value in that format.

------------------
Marco Kalter
Allround Automations

 

[watanove]

I see.

Thanks for your help,mkalter.

 

[RainerW]

Originally posted by mkalter:
In the current 3.4.6 release you need to use the to_char() function in your query to convert the timestamp to a varchar2, and treat it as a string field in your application. You will have to explicitly perform a conversion to TDateTime if you need the value in that format.