datatype storage questions

From: Mark Vantzelfde <markv_at_news.an.hp.com>
Date: 1995/05/23
Message-ID: <3psnlm$3ip_at_hpaneqb4.an.hp.com>#1/1

Can someone confirm that 7 bytes is the amount of storage for the date datatype? Is there a way to look in the database to get some firsthand confirmation?

What does the value from select avg(lengthb(col)), where col is of type numeric or date, reveal? Is the value returned the avg storage in bytes or the average display length or something altogether meaningless?

Received on Tue May 23 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Stan Novinsky: "Tables accessed from forms/triggers ?"
Previous message: Paul Nolan: "Winhelp with Forms 4"
Next in thread: Bob Swisshelm: "Re: datatype storage questions"
Reply: Bob Swisshelm: "Re: datatype storage questions"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message