Hi
I would like ti know the storage required for DATE, TIME and TIMESTAMP.
Please advise...
Thanks,
Maryam
Maryam Moazeni wrote:
I would like ti know the storage required for DATE, TIME and TIMESTAMP.
I assume you mean the disk space storage requirement for a column
of such a type?
One simple way to figure this out is to create a table containing
a column of such a type, store a few hundred
Maryam Moazeni:
I would like ti know the storage required for DATE, TIME and TIMESTAMP.
Take a look in java/engine/org/apache/derby/iapi/types - as far as I can
tell that's where the SQL data types live, in SQLDate.java, SQLTime.java
and SQLTimestamp.java. The comments explain how they're stored