Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: TimeStamp DataType??

Re: TimeStamp DataType??

From: José Luis Navarrete Fernández <jnavarretef.arion_at_nexo.es>
Date: 2000/07/19
Message-ID: <8l43n3$1jb$1@diana.bcn.ttd.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US