Re: simple date question

amit srivastava wrote:
>
> Hi,
>
> How many bytes does Oracle take to store a date field?
>
> What is the biggest date it can store?

Oracle takes 7 bytes to store the date field(one byte each for century, year, month,day, hour, minute and second)

Hope this helps

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  Certified Oracle DBA
  WHITTMAN-HART Inc.
  CHICAGO.