| Oracle DATE datatype internal structure [message #57512] |
Fri, 20 June 2003 00:15  |
Yasuhiro Ikeda
Messages: 4
Registered: June 2003
|
Junior Member |
|
|
Hi all,
I want to know DATE datatype internal structure for Oracle. I entountered a following WebLogic probrem.
http://e-docs.bea.com/wls/docs61/notes/ bugfixes2.html#1245159 <CR101517>
Our database has some wrong data in DATE before 1900. However I think they has some wrong data and some correct data. I want to know what is wrong and what si correct data. I know Oracle stored 7 bytes in DATE which is YYYY=2byte, MM=1byte DD=1byte HH24=1byte MI=1byte and SS=1byte.
SYYYY wrong? Dump (decimal)
---------- ---------- --------------------
YYYY A B
2003 correct 120 103
-0001 correct 100 099
0072 wrong 100 172
0072 correct 101 072
I think Oracle uses following fomura. Is it correct?
SYYYY = (A - 100) * 100 + (B-100)
--
Thanks,
Yasuhiro
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
