In 8.1.7.4, what is the length of a date column?
The DATE datatype can update, insert, or retrieve a date value using the Oracle internal date binary format. A date in binary format contains seven bytes, as shown below: BYTE 1 2 3 4 5 6 7 Meaning Century Year Month Day Hour Minute Second Example (for 30-NOV-1992, 3:17 PM) 119 192 11 30 16 18 1
HTH. Shripad Godbole OCP DBA (8,8i,9i) "Let's document it and call it a feature."
Forum Rules
Reply With Quote