Re: Timestamp Fractional Seconds

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 12 Jul 2007 06:27:06 +0200
Message-ID: <4695ad98$0$24921$426a74cc@news.free.fr>

"geoff" <nospam_at_nospam.com> a écrit dans le message de news: MVbli.33116$oA4.7458_at_fe04.news.easynews.com...
|I have an application that executes a select statement against a table where
| one of the columns is a timestamp and read the bytes returned by the OCI
| rather than use the time/date functions.
|
| I suppose this is legal since the memory layout is described here:
|
| http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci03typ.htm#CEGGCDCF
|
| . . . however, they want the fractional seconds also and that layout is not
| described other than it is 4 bytes. When I tried a select statement, the
| fractional seconds were returned in reverse byte order. Is this just a
| window thing or does Oracle do that?
|
| Thanks.
|
| --g
|
|
|

It is not 4 bytes, it is a long (4 bytes). Depending on your platfomr, the bytes are not in the same order.

Regards
Michel Received on Wed Jul 11 2007 - 23:27:06 CDT