Re: Timestamp Fractional Seconds

"geoff" <nospam_at_nospam.com> a écrit dans le message de news: Xpqli.73969$Ix4.22320_at_fe02.news.easynews.com...
| 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
|
|

It tooks it byte per byte but this is not byte variable but (double) word. So it depends on processor some are little endian other big endian, from this comes the difference.

Regards
Michel Received on Thu Jul 12 2007 - 11:30:28 CDT