Re: How to interpret date values in a trace file?

From: <wagen123_at_yahoo.com>
Date: 30 Jan 2007 11:13:36 -0800
Message-ID: <1170184416.833459.263050@s48g2000cws.googlegroups.com>

Steve/Yong,

The column data type is DATE and the application was using a TO_TIMESTAMP on this column (bug in thecode). This is what Oracle support said.

ANSWER

---

Bind 5= 2006-10-28 14:18:31.365
1C0A6A78 1520130F 004075C1

78=120 - 100= 20
6A=106 -100 = 06
0A=10 = 10
1C=28 = 28
0F=15 -1 = 14
13=19 -1= 18
20=32 - 1= 31

15c17540 = 365000000

Bind#6= 2007-01-26 14:18:31.365
1A016B78 1520130F 004075C1

78=120 -100= 20
6b=107 -100= 07
01=01 = 01
1a=26 = 26
of=15 -1 = 14
13=19 -1 = 18
20=32 -1 = 31

15c17540=365000000

There is an unpublished note that indicated for timestamp data, its in hex format and needs to be translated. The note is under edit and is notready yet for publishing. In any case, each byte in the 4 byte sequence needs to be swapped around beciuse its linux, then the hex value translates to decimal, then derive the date component values.

Thanks for your input. Received on Tue Jan 30 2007 - 13:13:36 CST