Re: Looking for the Oracle equivalent to MS SQL Server timestamp field

In Oracle 9i there is a new datatype - timestamp:

The TIMESTAMP datatype is an extension of the DATE datatype. It stores the year, month, and day of the DATE datatype, plus hour, minute, and second values. This datatype is useful for storing precise time values. Specify the TIMESTAMP datatype as follows:

TIMESTAMP [(fractional_seconds_precision)]

where fractional_seconds_precision optionally specifies the number of digits Oracle stores in the fractional part of the SECOND datetime field. When you create a column of this datatype, the value can be a number in the range 0 to 9. The default is 6. When you specify TIMESTAMP as a literal, the fractional_seconds_precision value can be any number of digits up to 9, as follows:

TIMESTAMP'1997-01-31 09:26:50.124' Mayby this is the functionality you are looking for?

//Gorm

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:Ecw4a.167346$vm2.121390_at_rwcrnsc54...
> Except the timestamp in sqlserver is somewhat a misnomer - it has nothing
 to
> do with time. You could use a sequence.
> Jim
> "Arch" <aguptill_at_nxtrend.com> wrote in message
> news:1951755c.0302181136.6fa723a5_at_posting.google.com...
> > I'm looking for the Oracle data type and possibly method to shadow the
> > MS SQL Server timestamp data type.
> >
> > From SQL Server Online help a timestamp is defined as:
> > timestamp is a data type that exposes automatically generated binary
> > numbers, which are guaranteed to be unique within a database.
> > timestamp is used typically as a mechanism for version-stamping table
> > rows. The storage size is 8 bytes.
> >
> > I'm not necessarily concernd that the datatype stays binary but the
> > funcationality is what I'm after. In particular is the notion of
> > ensuring that I can tell if a record has been updated since the data
> > was pulled that I'm now working with and possibly updating back to the
> > db system.
> >
> > Thanks in advance.
> > Arch
>
>
Received on Tue Feb 18 2003 - 22:55:14 CET