-
Can any one please clear my doubt. What is the size of a date data type in Oracle?
Thanks and regards
iyappan
-
Internally Oracle databases stores the DATE datatype in seven bytes.One byte for each of the century, year, month, day, hour, minute and second. You will find this documented in the Server Administrator's Guide, IIRC
[]s
Chiappa
-
Hello,
You can use the "vsize" fonction to have the number of bytes in the internal representation of your field.
try this : select vsize(sysdate) from dual;
Hope this helps
-
Originally posted by noor
Hello,
You can use the "vsize" fonction to have the number of bytes in the internal representation of your field.
try this : select vsize(sysdate) from dual;
Which will return you 8 instead of 7 (Oracle uses 7 bytes for storing dates)! We have just recently had two long threads about this isue in DBA forum...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|