Re: Timestamp Fractional Seconds
- From: "geoff" <nospam@xxxxxxxxxx>
- Date: Thu, 12 Jul 2007 13:56:07 GMT
Actually, they are the same order, I did this on a windows machine and unix
machines (non-pc hardware), the results were the same:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> create table tt (id number, ts timestamp);
Table created.
SQL> insert into tt values (1, '21-MAY-07 10:23:45.123');
1 row created.
SQL> select dump(ts) from tt where id = 1;
DUMP(TS)
--------------------------------------------------------------------------------
Typ=180 Len=11: 120,107,5,21,11,24,46,7,84,212,192
SQL>
.. . . the last 4 bytes are the fractional seconds and in reverse order for
all platforms.
-g
.
- Follow-Ups:
- Re: Timestamp Fractional Seconds
- From: Michel Cadot
- Re: Timestamp Fractional Seconds
- References:
- Timestamp Fractional Seconds
- From: geoff
- Re: Timestamp Fractional Seconds
- From: Michel Cadot
- Timestamp Fractional Seconds
- Prev by Date: Re: out soon from oracle 10g version 3 aka 11g
- Next by Date: Re: Minimizing backup induced downtime
- Previous by thread: Re: Timestamp Fractional Seconds
- Next by thread: Re: Timestamp Fractional Seconds
- Index(es):
Relevant Pages
|
