DATE IS a time stamp column. To prove this to yourself try something like
this:
SELECT TO_CHAR(date_col, 'DD/MM/YYYY HH24:MI:SS') FROM your_tab;
--
Jim Harrison
Colway Software and Design
http://www.colway.net
José Luis Navarrete Fernández <jnavarretef.arion_at_nexo.es> wrote in message
news:8l43n3$1jb$1_at_diana.bcn.ttd.net...
> 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
