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...
Originally posted by noor
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;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?