Re: Space required for different data types

I concur with Joel about checking the Guide. The date field, whether you store a date or time only, still contains a date and time. If you add a date only it will use 00:00:00 AM as the time. If you store just the time, you will get a date also. The date won't be what you might think it would. I have stored just the times and gotten default dates way in the future.

Don Hillsberry wrote in message <69qm9f$lfc_at_bgtnsc02.worldnet.att.net>...
>My DBA is not able to tell me how many bytes Oracle uses to store its
>different data types.
>Does anyone know?
>
>Also, is the date data type variable length? For example, does Oracle use
>the same space whether or not you store only date and not time or only time
>and not date?
>
>Thanks in advance for your help.
>Don Hillsberry
>
Received on Sat Jan 24 1998 - 00:00:00 CET