Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: TimeStamp DataType??
I refer to "stamp" columns. It's a binary data that db engine manage
automatically.
When you modified a row the engine updates this field with a new random
binary value.
In SQL Server this type of field is called "timestamp" and have 8 bytes of
length.
"Michel Cadot" <micadot_at_netcourrier.com> escribió en el mensaje
news:8l3ron$1ih$1_at_s2.feed.news.oleane.net...
> DATE datatype contains date and time.
> The quantum is the second.
>
> --
> Have a nice day
> Michel
>
>
> José Luis Navarrete Fernández <jnavarretef.arion_at_nexo.es> a écrit dans le
message :
> 8l3p5m$s66$1_at_diana.bcn.ttd.net...
> > Hi, I'm migrating a database from SQL Server 7.0 to Oracle8.
> > I have a TimeStamp colunm in one of SQL Server Tables.
> >
> > Has Oracle a TimeStamp DataType?
> >
> > Thanks.
> > --
> > José Luis Navarrete Fernández
> >
> >
> >
>
>
Received on Wed Jul 19 2000 - 00:00:00 CDT