Re: Timestamps in Oracle, Newbie question!

Hi Paolo,

we migrated a DB2 application to Oracle. As there is no timestamp in Oracle we took a CHAR(26) column. We filled it with date(including time) and a sequence for the last 6 digits.
If you don't need the timestamp as a primary key, you can take a date field instead.

Bye

Bernd

--
Bernd Dormann
Lufthansa Systems AS

Paolo Rossi wrote:
>
> Hi!
> We are trying to migrate an application from DB2 UDB 5.2 to Oracle 8
> and are encountering some problems with timestamp fields!
>
> The problem lies in the fact that in DB2 timestamp fields have a
> format like yyyymmdd-hh.mm.ss.xxxxxx which is something we have not
> been able to obtain in Oracle!
>
> Could anyone please tell me how timestamps are treated in Oracle and
> how can I format such fields in a as close as possible way to the DB2
> format, in order to maintain the application as transparent as
> possible to the DB platform in use?
>
> TIA
>
> Paolo Rossi
Received on Mon Jul 12 1999 - 07:32:25 CDT