Re: Timestamp Fractional Seconds

From: geoff <nospam_at_nospam.com>
Date: Thu, 12 Jul 2007 13:56:07 GMT
Message-ID: <Xpqli.73969$Ix4.22320@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
Received on Thu Jul 12 2007 - 08:56:07 CDT